Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Getting Year and Quarter on the same axis in a line chart

Hi

Qlik Enthusiasts

I have  a requirement as shown in the attached image.

Can anyone help me with the solution or workaround?

Thanks and Regards

Manoj

1 Reply
Partner
Partner

How is your data constructed? I mean in the script?

This would only be possible if u do things in the script to create this new dimension: 

I mean creating a new table like  this :

NewTable:

load Year as NewDimension, sum(Measure) as YourMeasure resident table

  where Year>=2019 group by Year ;

concatenate(NewTable)

load QuarterYear as NewDimension, sum(Measure) as YourMeasure resident table

  where Year>=2019 group by QuarterYear ;

 

and use this NewDimension in the graph

dimension : NewDimension 

Measure: sum(YourMeasure)

 

Et voilà !