topic Re: How to ignore selections for variable in QlikView

How to ignore selections for variable

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

Hi All,

I have a chart with cities in the dimenions and expression as given below. I want the selections to affect the numerator but not the denominator which is a variable .

Count({<[SEGMENT] = {"*ABC*"}>} DISTINCT[ITEMS]) / vAbc

------------------

Variable declaration

vAbc = Count({<[SEGMENT] = {"*ABC*"}>} [ITEMS])

Thanks in Advance,

Arun

Re: How to ignore selections for variable

YoussefBelloum — Tue, 05 Jun 2018 10:07:50 GMT

Hi,

you can detach your variable from all the selections (all the fields) using this:

vAbc = Count({1<[SEGMENT] = {"*ABC*"}>} [ITEMS])

or just detach your variable from one field, city for example:

vAbc = Count({<[SEGMENT] = {"*ABC*"},[CITIES]>} [ITEMS])

Re: How to ignore selections for variable

shiveshsingh — Tue, 05 Jun 2018 10:27:20 GMT

YOu can bypass the field that you want not to impact the output.

Define your variable like below.

vAbc = Count({<[SEGMENT] = {"*ABC*"},[City]>} [ITEMS])

Re: How to ignore selections for variable

arunqlik2view — Tue, 05 Jun 2018 10:47:18 GMT

Thanks, you are awesome

Re: How to ignore selections for variable

YoussefBelloum — Tue, 05 Jun 2018 11:14:08 GMT

don't forget to close the thread if it is ok for you

Re: How to ignore selections for variable

dsharmaqv — Tue, 05 Jun 2018 11:27:45 GMT

try this

vAbc = Count({<[SEGMENT] = {"*ABC*"},Cities=>} [ITEMS])