topic Re: Ignore Selections Query. in QlikView

Ignore Selections Query.

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

Hi QV Team,

I've a variable in text box object (vPreviousYear).

how to ignore all selections for this variable? Any selections that does not affect to this text box object.

Variable

vPreviousYear = num(sum({<FactType={IO},Jahr={$(vPY)}>}NET_VALUE_IN_EUR)*ExchangeRate,'#.##0')

devarasu07 — Wed, 12 Apr 2017 03:51:50 GMT

Hi,

Try like belowm

num(sum({1}{<FactType={IO},Jahr={$(vPY)}>}NET_VALUE_IN_EUR)*ExchangeRate,'#.##0')

if you wanted to exclude few dimension prompt,

Let's Say you have Year & Month Filter

and a measure is :Sales

then you write like below,

sum ( {<Year = , Month = , [add your other modifier] >} Sales)

Hope this helps you

Regards,

Deva

MuraliPrasath — Wed, 12 Apr 2017 04:10:58 GMT

Thanks Devarasu! Have a good day.