Exclude a member of a dimension

[#1]

Hi all,

I have been working in Tableau for over three years and am trying to learn QlikView. So far, I'm having a hard time wrapping my head around the differences, particularly as it pertains to expressions, sets, and filtering.

My question is embarrassingly simple, but I have struggled to answer it.

I have a dimension called 'Buyer'. There are 11 types of buyers, e.g. 'CEO', 'CISO', etc. Among the Buyer types is 'Other'. I want to exclude it from my QlikView app completely. How would I do that? My searching hasn't helped.

Thanks,

Doug

[rajpreeths]

Hi..

Wherever you load your 'BUYER'  dimension write the below where conditions so that others category would not get into your application.

Sample

LOAD

x,

Y,

Buyer,

Z....

From

..something....

WHERE Buyer<>'Others';

[#3]

Thanks, Rajpreeth. So the time and place to do this is in the load script and not using some sort of expression in the app?

[rajpreeths]

Yes..

You are right.. Field values can be limitted in the script.Please close this thread if information made you clear so that other users can make use of this marked answer..

[MarcoWedel · Accepted solution]

Hi,

other front end solutions to exclude this value from e.g. charts would be

- calculated dimensions like

  If(Buyer<>'Other', Buyer)    (checking the "Suppress When Value is Null" dimension option)

- some set expression in your chart's aggregation functions like

  Sum({$<Buyer-={'Other'}>} somefact)

Set expression should be preferred here (only if excluding in the script is no solution for you.)

hope this helps

regards

Marco

[Anonymous]

Yes ,you can use expressions to avoid,

Sum({<Dimesion-={'Other'}>]Sakes).

[#7]

Thanks to all for the help. Much appreciated.

[#8]

hi marco. why your qvw file, not opening in my personal edition qlikview 12.

is there any restiction on Personal Edition

[Anil_Babu_Samineni]

Yes, you require license for that. Anyway, have you solve the issue

[#10]

for learning purpose not for commercial purpose, how much it cost ? any clue?