Discussion board where members can get started with QlikView.
Hi Experts ,
I have the following data loaded in the Report :
LOAD RequestId ,
I want to display the Financial Year >> Year >> Quarter>> MonthName in the hierarchial manner in the Dashboard.
I tried using the Hierarchial load method.
But that doesnt seem to be working.
Kindly Suggest on how can this be acheived.
Thanks in advance
Go to Solution.
Take a look at this one, try to adapt on your final app and let me know
you can create a concatenated field (including all the calendar fields you want) and use the "show as treeview" option in a listbox
Hi Youssef ,
yes i have tried this , but this seems to show like below:
It only shows the months in white..
and i am not able to select the FY or Years also.. i have to drill down all the way to months and then select , tried changing the style of the component.
How can i acheive this,
any ideas please share.
I know, it is working like this. you can only select the most detailed level.. otherwise you should use again the Hierarchy method..
would you be able to share sample app to see what is going wrong with the hierarchy method ?
Attached is the QVW file with the sample data of the date.
Tried Hierarchy load.
Doesn't seem to work at all,
Kinldy help me out in this.
Can you please attach the source (sample 70 data) to be able reload or do yo want me to create for you another sample data ?
Here It is , Find the attached
first time I made a hierarchical calendar
it was a headache I swear, but at least it works
PS: you can't make it work with your excel (you have date format problem, I couldn't know what it is..)
I'll let you try to connect these two tables
Thanks a lot for the File , i am trying to implement it .
Also wanted to ask you , in your file , on selection of any entry in the h_Date list box , the data is not getting filtered.
Is that happening with u also ? Kinldy check and let me know.
actually I didn't finish it, the h_date is not yet connected to the data table..
if you can not find solutions to connect them, let me know