Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

hierarchy calender

Hi Experts ,

I have the following data loaded in the Report :

LOAD RequestId ,

     DisplayId ,

     CreatedBy,

     Date,

     Year,

     MonthNumber,

     MonthName,

     Quarter,

     FinancialYear

From ViewName;

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

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Take a look at this one, try to adapt on your final app and let me know

View solution in original post

32 Replies
YoussefBelloum
Champion
Champion

Hi,

you can create a concatenated field (including all the calendar fields you want) and use the "show as treeview" option in a listbox

Anonymous
Not applicable
Author

Hi Youssef ,

yes i have tried this , but this seems to show like below:

calender issue.png

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.

Thanks

YoussefBelloum
Champion
Champion

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 ?

Anonymous
Not applicable
Author

Hi ,

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.

Thanks

YoussefBelloum
Champion
Champion

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 ?

Anonymous
Not applicable
Author

Hi ,

Here It is , Find the attached

Thanks

YoussefBelloum
Champion
Champion

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

PFA

Anonymous
Not applicable
Author

Hi ,

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.

Thanks

YoussefBelloum
Champion
Champion

no problem

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