Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chandana_gowdar
Contributor II

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
Esteemed Contributor

Re: hierarchy calender

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

View solution in original post

31 Replies
YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

Hi,

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

chandana_gowdar
Contributor II

Re: hierarchy calender

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
Esteemed Contributor

Re: hierarchy calender

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 ?

chandana_gowdar
Contributor II

Re: hierarchy calender

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
Esteemed Contributor

Re: hierarchy calender

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 ?

chandana_gowdar
Contributor II

Re: hierarchy calender

Hi ,

Here It is , Find the attached

Thanks

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

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

chandana_gowdar
Contributor II

Re: hierarchy calender

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
Esteemed Contributor

Re: hierarchy calender

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