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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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