topic Re: how to filter pivot table data depending upon condition in QlikView

how to filter pivot table data depending upon condition

Fri, 26 Sep 2014 12:00:13 GMT

HI All,

I want to filter data of pivot table in qlikview.

For Ex: I will select Open in list box then I want only Open Complaint no.s and to decide whether that complaint no is open or close is depending on expression means if date resolved or that complaint no is > selected date then 'open' else 'close' then how to write condition to Complaint no column to suppress close complaint nos.

Re: how to filter pivot table data depending upon condition

sundarakumar — Sat, 27 Sep 2014 08:57:36 GMT

Create a list box

right click -> properties -> general tab -> field

the last option is <Expression>

choose it and copy paste the expression of open/close that was used in the pivot table.

This will create a list box with open and close. which will work as expected.

I guess ur open/close expression would be like

if(date>selecteddate,'open','close')

Hope this helps..

-Sundar

Re: how to filter pivot table data depending upon condition

kumarkp412 — Sat, 27 Sep 2014 09:18:43 GMT

By Guessing

In the pviot table ,we can use the expression in the dimension level.

When you are taking the dimension then on that ,if you to take dimension by exprission then you will get.

dimension->edit option for dimension use the below expression .

if(date>selecteddate ,'open',close)

Hope this helps you.

Thanks

Kumar

Re: how to filter pivot table data depending upon condition

ecolomer — Sun, 28 Sep 2014 03:29:54 GMT

Here's an example that may be helpful