topic Re: load only last quarter data in QlikView

load only last quarter data

mallireddy_qv6 — Sat, 16 Nov 2024 17:58:27 GMT

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

Re: load only last quarter data

Taoufiq_Zarra — Wed, 14 Oct 2020 07:43:47 GMT

@mallireddy_qv6 like ?

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

Re: load only last quarter data

MayilVahanan — Wed, 14 Oct 2020 08:46:51 GMT

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

Re: load only last quarter data

Brett_Bleess — Tue, 27 Oct 2020 16:37:04 GMT

@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/SetAnalysis/set-analysis-expressions.htm

Regards,
Brett