topic Re: How To Filter Dimension Members in QlikView

How To Filter Dimension Members

Fri, 16 Sep 2011 18:15:30 GMT

Hello,

I have a listbox using dimension called Partner, and it contains all the available Partner list.

However, for the specific Hotel chart, I only want the listbox to show Partner that have Booking>0

Here's the Booking expression: Sum({<LOB={HOTEL}>}Booking)

How do I use an expression in the listbox to return only the Partner with Booking>0?

Your help is appreciated!

Fri, 16 Sep 2011 19:34:16 GMT

Hi,

This should work:

if(aggr(Sum({<LOB={HOTEL}>}Booking),Partner)>0,Partner)

Regards,

Kiran

Tue, 20 Sep 2011 23:58:18 GMT

Similar question on dimension filtering.

I currently have a chart that I am filtering top 10 by presentation property "Max Visible Number"=10

I want to remove this filter, and apply it in the Dimension coding.

How do I filter top 10 Partner Dimension based on the following expressions in decending order

Sum({<LOB={HOTEL}>}Booking)

Your help is appreciated.

Wed, 21 Sep 2011 02:13:08 GMT

Instead of the aggr function you can use rank function with condition rank <=10.

Regards,

Kiran.