Select Value Range to Show in Pivot Chart Expressi... - Qlik Community

Report Inappropriate Content · ‎2012-09-04

Hi all,

As in a straight table, I can use dimension limit tab to define the value range that I want to show in the expressions.

However, in a pivot table, the dimension limit tab just disappears. Can I know is there a similar solution to pivot table? (besides doing it in SQL)

Thanks.

whiteline · ‎2012-09-05

Use calculated dimensions (and set analysis if needed):

=If(YourValueRangeCheck, YourDimension, null())

Select Value Range to Show in Pivot Chart Expression