topic Limiting Data in a Pivot Chart in QlikView

Limiting Data in a Pivot Chart

Anonymous — Sat, 20 Jun 2009 00:15:31 GMT

I have a chart that calculates how many weeks of supply are on hand for all products. I need the pivot to only show those products where the weeks supply is less than 2 weeks but I can't seem to figure out how to do this. Please see the attached screen shot of the chart.

Limiting Data in a Pivot Chart

Sat, 20 Jun 2009 00:30:42 GMT

What you could do is add some logic to your expressions to set them to Null if the supply is greater than 2 weeks. If every expression is Null for a specific record, it will not appear on the chart (if you set hide Null values).

Expression: If("Wk Supply" < 2, Current Expression, Null)

If you set up all the expressions like that, the only records that will appear are the ones with a supply less than 2.

Limiting Data in a Pivot Chart

Anonymous — Sat, 20 Jun 2009 00:48:01 GMT

Well that was just too easy. LOL

Thanks!