Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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?

xufei123
Partner
Partner

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

sumitkulkarni
Contributor III
Contributor III

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 II
Specialist II

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.