Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

current quarter and last quarter sale

Hi all,

i am having year,month,quarter fields 
now in text object i want to show current quarter and previous quarter sale,please reply me if anyone know this.

year =2016,2017,2018,2019
Month= Apr,May,June,July......
Quarter=Qtr-1,Qtr-2,Qtr-3,Qtr-4.

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

You can use set analysis to achive this.
Something like below for Current quarter
Sum({<Year={"$(=Year(today()))"},Quarter={"$(='Q' & Ceil(month(today())/3))"}>}Sales)
Brett_Bleess
Former Employee
Former Employee

Venkatesh, did Dilip's post work for you?  If so, please use the Accept as Solution button to give him credit and let others know that solution worked.

The only other things I have are the following:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.