topic pivot table expression condition in QlikView

pivot table expression condition

Wed, 25 Nov 2020 16:16:04 GMT

Hi i have a pivot table. how can not show the value which is smaller than 1000. do i need to code in expression or is there way to do this thanks

Re: pivot table expression condition

devarasu07 — Wed, 29 Mar 2017 04:06:55 GMT

Hi,

In your Pivot table expression try to put below kind expression,

Sum({<EmployeeID={"=sum(Freight)>1000"}>} Freight)

Refer to the sample attachment,

Hope this help to you

Regards,

Deva

Re: pivot table expression condition

rahulpawarb — Wed, 29 Mar 2017 09:08:33 GMT

Hello Gill,

Trust that you are doing good!

As you mentioned, you can code your expression in the required manner (expression definition or conditional at expression level) or you can devise a table with values less than 100 using resident load. Post that refer that table in presentation layer.

Hope this will be helpful.

Regards!

Rahul