topic Re: Exclude a member of a dimension in QlikView

Exclude a member of a dimension

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Exclude a member of a dimension

rajpreeths — Fri, 30 Sep 2016 18:35:28 GMT

Hi..

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

Sample

LOAD

Buyer,

Z....

From

..something....

WHERE Buyer<>'Others';

Re: Exclude a member of a dimension

Fri, 30 Sep 2016 18:44:43 GMT

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?

Re: Exclude a member of a dimension

rajpreeths — Fri, 30 Sep 2016 18:50:25 GMT

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..

Re: Exclude a member of a dimension

MarcoWedel — Sat, 01 Oct 2016 01:36:45 GMT

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

Re: Exclude a member of a dimension

Anonymous — Mon, 03 Oct 2016 09:53:27 GMT

Yes ,you can use expressions to avoid,

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

Re: Exclude a member of a dimension

Mon, 03 Oct 2016 10:05:49 GMT

Thanks to all for the help. Much appreciated.

Re: Exclude a member of a dimension

Mon, 03 Oct 2016 10:09:26 GMT

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

is there any restiction on Personal Edition

Re: Exclude a member of a dimension

Anil_Babu_Samineni — Mon, 03 Oct 2016 10:25:08 GMT

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

Re: Exclude a member of a dimension

Mon, 03 Oct 2016 10:31:25 GMT

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