Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have created a quarter dimension on my data like following
Div(Month([timestamp]), 3) as season,
I have made a pie chart on this dimension showing data in different quarter periods. The labels on these pie slices are obviously 0,1,2,3 and I would like them to be Q1, Q2, Q3, Q4.
How do I do this in the best way?
Go to Solution.
You could change your dimension to the following:
'Q'&Div(Month([timestamp]), 3) as season
Or in case you want to keep your current dimension, just add the new one bellow:
Div(Month([timestamp]), 3) as seasonNumber,
Hi Viktor - try this:
'Q' & Ceil(Month(OrderDate)/3) as Quarter
Let us know how you do.
Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.