Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to load last quarter data in straight table. with these conditions. sum(TotalSales)
Destination not in "trek" and 'nean"
customerflag is equal to "y"
how can I write set expression
@mallireddy_qv6 like ?
=sum({<Destination={"*"}-{trek,nean},customerflag={'y'}>} TotalSales)
Hi MalliReddy,
Try like this
Sum({<Date = {">=$(=Date(QuarterStart(Max(Date),-1),'YYYY-MM-DD'))<=$(=Date(QuarterEnd(Max(Date),-1),'YYYY-MM-DD'))"}, customerflag ={'Y'}, Destination -={'trek', 'nean'}>}TotalSales)
Replace the Date field with your fieldName.
Hope it helps
@mallireddy_qv6 you have two possible solutions posted, please return to the thread and review and close the thread by using the Accept as Solution button on the post(s) that helped. If you did something different, you can post that separately and then use the button to mark that post.
Here are a couple of other links that may be helpful in the future:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Regards,
Brett