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: 
antonaks
Creator II
Creator II

The range of values in the SetAnalisys using variables

Hello everybody!


I have a problem with next expresion:

It is not works (result is 0):

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom)<=$(vBonusTo)"}>} balance)


When I use form with out second condition of range all works good.


For example:

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom)"}>} balance)


Show me please. Where is my mistake?

1 Solution

Accepted Solutions
marcus_sommer

Try it with:

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom) and sum(balance)<=$(vBonusTo)"}>} balance)

- Marcus

View solution in original post

7 Replies
marcus_sommer

Try it with:

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom) and sum(balance)<=$(vBonusTo)"}>} balance)

- Marcus

antonaks
Creator II
Creator II
Author

Super! Thank you very much!

jyothish8807
Master II
Master II

Try this once:

sum({<first_last_name= p({<$(=sum(balance))>=$(vBonusFrom)>})*p({<$(=sum(balance))<=$(vBonusTo)>})>}balance)

Best Regards,
KC
antonaks
Creator II
Creator II
Author

Sorry, but this variant not working.

jyothish8807
Master II
Master II

No problem Just for my curiosity can you please try this one also ?

sum({<first_last_name= p({<sum(balance)>=$(vBonusFrom)>})*p({<sum(balance)<=$(vBonusTo)>})>}balance)


Br,

KC

Best Regards,
KC
antonaks
Creator II
Creator II
Author

Hi!

Unfortunately not work too.

Anton.

jyothish8807
Master II
Master II

Best Regards,
KC