load only last quarter data

[mallireddy_qv6]

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

[Taoufiq_Zarra]

@mallireddy_qv6  like ?

=sum({<Destination={"*"}-{trek,nean},customerflag={'y'}>} TotalSales)

[MayilVahanan]

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

[Brett_Bleess]

@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

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett