Help Center
Vizlib Community
Questions
Pivot Table - Calculating Measure only For Specific Dimension

Answered

Pivot Table - Calculating Measure only For Specific Dimension

P

Prateek

started a topic about 2 years ago

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 -

Daniel Adesanya
said about 2 years ago

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 https://community.vizlib.com/helpdesk/tickets/25019

Best,

Daniel Adesanya

Vizlib Support Engineer
O

Or Shoham
said about 2 years ago

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

Prateek
said about 2 years ago

Thanks "Or Sohom" You are a saviour !

Login to post a comment

Didn't find what you were looking for?

Start a new topic