Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

Convert months to Quarter in bar chart after month ends

Hi Team,

Here i need to some help  related to set expression that am unable to solve. Please help me how to design like below and how to write set expression for this.

Examples: I have sales for this Year. Whenever the 3months completed it should show under  Quarter-'Q'.

This is my expression for 2018 and 2019.

=Sum({$<Date= {">=$(=Date(AddYears(YearStart(Today()),-1)))<$(=Date(AddYears(Today(),-1)))"}>} Sales)

2019:

=Sum({<{">=$(=Date(yearstart(AddMonths(V_Max_Creation_date,-0)),'M/D/YYYY')) <=$(=Date(YearEnd(AddMonths(V_Max_Creation_date,-0)),'M/D/YYYY'))"}>} Sales)

Dimension: Month

Jan,Feb and Mar it should come under 'Q1', Apr,May,June come under 'Q2'. Now July started it should be in July month.

Thanks in Advance. 

barchart.PNG

0 Replies