Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

how to show 3 dimensions on x-axis ? As shown below -

3 dimensions.PNG.png

Tags (1)
7 Replies
MVP
MVP

Re: how to show 3 dimensions on x-axis ? As shown below -

is it an option to concatenate two of them (quarter and month or year and quarter)?

Not applicable

Re: how to show 3 dimensions on x-axis ? As shown below -

You could concatenate dimensions using Calculated Dimension Option in charts. Like Year & Quarter, Quarter & month, etc.,

Eg. statement : =aggr(date(YearMonth,if(Month=min(total <Year> Month),'YYYY MMM','          MMM')),Year,YearMonth)

Not applicable

Re: how to show 3 dimensions on x-axis ? As shown below -

No, Need to show all 3 dimensions.

I have used Dummy variable to show 2 dimensions but it doesn't work for 3.

2 dimensions.PNG.png

Not applicable

Re: how to show 3 dimensions on x-axis ? As shown below -

Sorry, but Aggr(Year(Date),Quarter)  or  Aggr(Quarter, Month(Date) ) didn't work. I want to display Month, Quarter and Year values on X-axis.

Not applicable

Re: how to show 3 dimensions on x-axis ? As shown below -

Is there any way I can display Month, Quarter and year on same axis ?

Not applicable

Re: how to show 3 dimensions on x-axis ? As shown below -

You first have to create YearQuarterMonth field in script. Then using this aggr function need to pull out x-axis dimension similar to how my expression takes Year & Month.

There could be other solutions too. Let me check and get back to you.

Thanks,

Madhu

Not applicable

Re: how to show 3 dimensions on x-axis ? As shown below -

Thanks Madhu, I will check this. Please let me know if you find other solution.

Community Browser