Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zain_ismail
New 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
Valued Contributor

Re: Set Analysis

what about

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

zain_ismail
New Contributor II

Re: Set Analysis

Nope, still does not work

zebhashmi
Valued Contributor

Re: Set Analysis

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

zain_ismail
New Contributor II

Re: Set Analysis

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

xufei123
Valued Contributor

Re: Set Analysis

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

sumitkulkarni
New Contributor III

Re: Set Analysis

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
New Contributor II

Re: Set Analysis

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
Valued Contributor

Re: Set Analysis

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.

Community Browser