Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Creating custom label

I have created a quarter dimension on my data like following

Load

...    

     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?

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Creating custom label

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,

'Q'&Div(Month([timestamp]), 3) as season

...

2 Replies
Employee
Employee

Re: Creating custom label

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.

Regards,

Mike

Not applicable

Re: Creating custom label

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,

'Q'&Div(Month([timestamp]), 3) as season

...