topic Re: Pivot Table Filter in QlikView

Pivot Table Filter

Fri, 09 May 2014 01:41:20 GMT

Hello,

I have created a Pivot table and I want to find out how can I exclude certain records from the results. For example I want to include all records from column LY Rolling 6 months greather than 5000 but only if the % Change is greather than -15%

This has to be a Pivot because and not a staright table. I have the following working formula as my LY Rolling 6 months (but I need to find a way to restrict the records)

If('$(vViewMode)'='Units',
Sum({$<PeriodID ={">$(vPreviousPeriodID(18)) <=$(vPreviousPeriodID(12))"},Year=,Month=,Collection-={'Others'}>}qty)

,
sum({$<PeriodID ={">$(vPreviousPeriodID(18)) <=$(vPreviousPeriodID(12))"},Year=,Month=,Collection-={'Others'}>} $(vNetAmount)*RateConverted))

Re: Pivot Table Filter

Gysbert_Wassenaar — Fri, 09 May 2014 09:39:13 GMT

Try using Dimension Limits. See attached qvw for an example.

Re: Pivot Table Filter

Fri, 09 May 2014 14:15:09 GMT

Thank you Gysbert,

But when working with Pivot tables you don’t have the option for Dimension Limits. Even if I could change my Pivot to Straight table (I prefer not to because the report is cleaner as a Pivot). I am looking for a dual condition in this case; show only totals greater than 5000 if the % Change is -15 or lower (-12, -10, etc)

Hugo