If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
How many years do you have?
You have 28 Excel table with that format??
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?
All year months and quarter are in rows
How so? Can you screen shot your data source with 2 years?
I'm trying to help; you're not facilitating it
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.
I have attached the document.