Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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à !