Discussion board where members can get started with Qlik Sense.
My query is how can i create hierarchy from the below data , as i have different rows with years,months and quarter. I need to make a drill down of year , month and quarter in a graph.
Any suggestion on how to create it into separate dimensions drill down?
can you attach the 1980 , 1981 and 1982 excel files?
So that I can see how implement a generic way to transform all of your tables into the desired format and be thus able to create your hierarchy?
Here is the script:
crosstable (MonthYear,Value,2) load
from your data;
subfield(MonthYear,'M',1) as Year, //seperate Year
subfield(MonthYear,'M',2) as Month, // seperate Month
'Q' & ceil(subfield(MonthYear,'M',2)/3) as Quarter, //create Quarter
where MonthYear like '*M*';
drop table Temp;
Maybe add other timefields you need.