topic Pivot Table in QlikView

Pivot Table

Mon, 29 Feb 2016 05:36:56 GMT

Hi friends, I have a question:

I have a pivot table with 4 fields: Country, Code, Person, Sales.

I want to get a new table with records of the above pivot table that sales is greater than 10000$.

I need to report new table by Email or PDF file.

TNX

marcus_sommer — Tue, 01 Mar 2016 09:44:56 GMT

You will need a calculated dimension as filter in one of your dimension for this, like:

if(aggr(sum(Sales), Country, Code, Person)>10000, Country)

and then hiding NULL within this dimension: Calculated Dimensions

- Marcus