Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Hide Quarter on X-axis

Hi,

I came across one requirement where we want to hide our Quarter on axis for which one of the month does not have data.

means show quarter only if that has data for all 3 months.

 

Labels (1)
4 Replies
Highlighted
Creator
Creator

Re: Hide Quarter on X-axis

A:
load * inline [
Month, Quarter,year,Sales
January, Q1,2018,100
February, Q1,2018,200
March, Q1,2018,100

April, Q2,2018,300
June, Q2,2018,400

July, Q3,2018,100
August, Q3,2018,300
September, Q3,2018,200

October, Q4,2018,100
December, Q4,2018,400
];
exit script;

Dim:=if(aggr(count(Month),Quarter)=3,Quarter)
Meas:sum(sales)
if you have 4 months under one quarter then change the count from 3 to 4.
Highlighted
Master
Master

Re: Hide Quarter on X-axis

sample data?

Highlighted
Creator
Creator

Re: Hide Quarter on X-axis

clipboard_image_0.png

Highlighted
Digital Support
Digital Support

Re: Hide Quarter on X-axis

Chinmay, did Sugathi's posts help you get what you needed?  If so, please do not forgot to circle back and give them credit by using the Accept as Solution button on the post that helped.  If you have done something else, please consider posting that solution and making that as the solution with the button after you post it.  If you require further help, please provide an update on where things stand. 

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.