topic Re: filters pivot table in QlikView

filters pivot table

Wed, 13 May 2015 20:08:32 GMT

Hello,

I have a pivot table with the following fields :

Dim1

Dim2

Dim3

sum(val1)

sum(val2)

sum(val3)

I need to know how can I filters records with the following condition :

sum(val1) > 1000 and sum(val2) < 2000

Thank you

PrashantSangle — Thu, 14 May 2015 05:16:39 GMT

Hi,

Create your expression in Script level and there you can manipulate it.

Regards

tresB — Thu, 14 May 2015 05:27:24 GMT

One way could be like:

Rewrite the expressions like:

Exp1: If( sum(val1) > 1000 and sum(val2) < 2000 , 0 , sum(val1))

Exp2: If( sum(val1) > 1000 and sum(val2) < 2000 , 0 , sum(val2))

Exp3: If( sum(val1) > 1000 and sum(val2) < 2000 , 0 , sum(val3))

And enable the 'Supress Zero Values' in the presentation chart.

jagan — Thu, 14 May 2015 05:29:14 GMT

Hi,

Try like this

If(sum(val1) > 1000 AND sum(val2) < 2000, "You expression here")

Regards,

Jagan.

Thu, 14 May 2015 05:54:56 GMT

Please find solution in attachment and let me know .