Ignore Selections Query.

[MuraliPrasath]

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 · Accepted solution]

Hi,

Try like belowm

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

or

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]

Thanks Devarasu! Have a good day.