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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select lines from column Month to present a chart in quarters

Hi,

I have a colunm Years and a Column Months, but i need to present my information in a graphic (no matter wich) in quarter of months -

e.g. 1º quarter....2º quarter....3º quarter.....4º quarter...

So I need to operate the lines of my column Months.

Anyone knows how I can do that?

Please help.

Thank you in advance

1 Reply
Not applicable
Author

'Q' & Ceil(Month(date)/3) as Quarter

Put this in your script and change the date to your date field