How to ignore selections for variable

[arunqlik2view]

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

[YoussefBelloum]

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])

[shiveshsingh]

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

Define your variable like below.

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

[arunqlik2view]

Thanks, you are awesome

[YoussefBelloum]

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

[dsharmaqv]

try this

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