how to filter pivot table data depending upon condition

[#1]

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.

[sundarakumar]

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

[kumarkp412]

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

[ecolomer]

Here's an example that may be helpful