Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chinmay7
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
sugathirajkumar
Creator
Creator

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.
shiveshsingh
Master
Master

sample data?

sugathirajkumar
Creator
Creator

clipboard_image_0.png

Brett_Bleess
Support (Former)
Support (Former)

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.