topic Re: Pick only certain Category Values in a variable. in QlikView

Pick only certain Category Values in a variable.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi anyone,

I am looking for help on how to get the dimension only for certain categorical values while writing expression.

I have 3 columns Website, StockIndicator and Products.

Problem statement:

Under each Website i have to count how many Products are available under StockIndicator Yes, No where in StockIndicator i have 4 different categorical values

Yes, No, Not Available and Null

example to achieve results

Website StockIndicator Products

ABC Yes 100

A2Z Yes 50

A2Z No 50

I should eliminate Other Categories in StockIndicator which i should do it in Expression not in Load.

Re: Pick only certain Category Values in a variable.

YoussefBelloum — Wed, 21 Feb 2018 13:55:33 GMT

Hi,

on a simple table chart, put Website and StockIndicator as a dimensions, and use this as an expression:

=sum( {<StockIndicator={'Yes'}>} Products)

It will count how many products you have on every website only for StockIndicator 'Yes'

Re: Pick only certain Category Values in a variable.

Anonymous — Wed, 21 Feb 2018 14:06:24 GMT

Thank you Youssef. But this is giving me result only for Yes. I also need No . How to add or condition!

Re: Pick only certain Category Values in a variable.

YoussefBelloum — Wed, 21 Feb 2018 14:11:33 GMT

Like this :

=sum( {<StockIndicator={'Yes','No'}>} Products)

Re: Pick only certain Category Values in a variable.

Anonymous — Wed, 21 Feb 2018 14:18:47 GMT

It Worked. Thank you very much for educating me.

Re: Pick only certain Category Values in a variable.

YoussefBelloum — Wed, 21 Feb 2018 14:30:14 GMT

you're welcome.

it is called SET ANALYSIS, make some research on it, you will have to use it, and it can be much more complicated than the one I gave you.

Good luck