Vizlib Home Try Vizlib

Pivot Table - Calculating Measure only For Specific Dimension

Is is possible to calculate as per below exacple

                          Annual Sales   % Change    

Product A >           $X                       Y%

Sub Product A1>   $X1                  Don't calculate > Show Blank or -

Sub Product A2>   $X2                  Don't calculate > Show Blank or -

  • Hi Prateek,

    I hope you're well and safe?

    Thank you for contacting us. Regarding this query have you tried using the calc.condition section of the Dimensions? 

    Please note your unique ticket reference (#25019) and URL


    Daniel Adesanya

    Vizlib Support Engineer
  • We do this a lot - you'd typically do this natively in Qlik (Sense or View) by using Dimensionality() in our expressions.

  • Thanks "Or Sohom" You are a saviour ! 

Login to post a comment