topic Hide Quarter on X-axis in QlikView

Hide Quarter on X-axis

chinmay7 — Sat, 16 Nov 2024 20:06:37 GMT

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.

Re: Hide Quarter on X-axis

sugathirajkumar — Tue, 10 Sep 2019 06:36:48 GMT

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.

Re: Hide Quarter on X-axis

shiveshsingh — Tue, 10 Sep 2019 06:40:06 GMT

sample data?

Re: Hide Quarter on X-axis

sugathirajkumar — Tue, 10 Sep 2019 07:15:42 GMT

Re: Hide Quarter on X-axis

Brett_Bleess — Mon, 23 Sep 2019 15:23:29 GMT

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