Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what about
sum({<NetSalesValue = {">=0<=750"}>} NetSalesValue)
Nope, still does not work
works for me the similar condition can you share some data or file?
Are you able to maybe do a teamviewer session with me?
if(sum(NetSalesValue)>=0 and sum(NetSalesValue)<=750,sum(NetSalesValue))
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
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!!!!!
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.