Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Ignore Selections Query.

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

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

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

View solution in original post

2 Replies
devarasu07
Master II
Master II

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
Creator III
Creator III
Author

Thanks Devarasu! Have a good day.