topic Re: Restrict Dimension in QlikView

Restrict Dimension

upaliwije — Fri, 21 Nov 2014 09:06:08 GMT

Hi Friends

I have Pivot Table with following columns

Note Amount

100 500

101 100

102 300

103 600

104 400

105 200

.... ....

I want to restrict display of dimension note 100,103,105. I want to do this without manually selecting from a list box. Pls help me to do it

marwen_garwachi — Fri, 21 Nov 2014 09:09:34 GMT

Try in dimension : if(wildmatch(Note,100,103,105),Note)

PrashantSangle — Fri, 21 Nov 2014 09:10:00 GMT

Hi,

USe calculated Dimension,

Try like

if(wildmatch(Note,'100','103','105'),Note)

And select Supress Null Values in Dimension tab

Regards

Anonymous — Fri, 21 Nov 2014 09:13:27 GMT

Hi ,

In the dimension use the below expression

=IF(Note <>'100' and Note <>'103' and Note <>'105',Note)

Please find the sample application in the attachments.....

upaliwije — Fri, 21 Nov 2014 10:30:56 GMT

Thanks all