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: 
zain_ismail
Contributor II
Contributor II

Set Analysis

Hi Guys

I am new to Qlik and need some assistance. below is a formula I'm trying to use but not getting the correct results.

sum({<NetSalesValue = {">=$('0')<=$('750')"}>} NetSalesValue)

the results returned is ignoring my conditions.

please point me in the right direction.

Thanks

8 Replies
zebhashmi
Specialist
Specialist

what about

sum({<NetSalesValue = {">=0<=750"}>} NetSalesValue)

zain_ismail
Contributor II
Contributor II
Author

Nope, still does not work

zebhashmi
Specialist
Specialist

works for me the similar condition can you share some data or file?

zain_ismail
Contributor II
Contributor II
Author

Are you able to maybe  do a teamviewer session with me?

NZFei
Partner - Specialist
Partner - Specialist

if(sum(NetSalesValue)>=0 and sum(NetSalesValue)<=750,sum(NetSalesValue))

Anonymous
Not applicable

Hi Zain,

You can use If statement as mentioned by Fei however, it is recommended to use set analysis in order to improve performance, so in this case the below mentioned expression would defiantly work, if not then can you share some data or file.

sum({<NetSalesValue = {">=0<=750"}>} NetSalesValue)



Thank you!


Best Regards,

Sumit K

zain_ismail
Contributor II
Contributor II
Author

Hi Guys

Thank you so much for your assistance. I did manage to get it working correctly.

All the solutions given we correct, I missed out the quotes initially.

you guys ROCK!!!!!

JustinDallas
Specialist III
Specialist III

You can mark someone answer's as correct.  That way, when someone else has the same problem and they run across this thread in their Google search, they will know that the answer only lies a few posts away.