Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
chandana_gowdar
Contributor II

Hierarchy Calendar

Hi all, 

Below given is the sample data for calendar i have, i want to display this in hierarchy format in the dashboard.

TestCalender:

LOAD * INLINE [

    Date, [Financial Year], Year, Quarter, Month

    01-07-2017,FY17, 2017, Q1, July

    01-08-2017,FY17, 2017, Q1, August

    01-09-2017,FY17, 2017, Q1, Spetember

    01-10-2017,FY17, 2017, Q2, October

    01-11-2017,FY17, 2017, Q2, Novmber

    01-12-2017,FY17, 2017, Q2, December

    01-01-2018,FY18, 2018, Q3, January

    01-02-2018,FY18, 2018, Q3, February

    01-03-2018,FY18, 2018, Q3, March

    01-04-2018,FY18, 2018, Q4, April

    01-05-2018,FY18, 2018, Q4, May

    01-06-2018,FY18, 2018, Q4, June

];

Kindly help on how to display this.

Thanks in advance

1 Solution

Accepted Solutions
chandana_gowdar
Contributor II

Re: Hierarchy Calendar

Hi Youssef ,

Your Suggested option donot work , as i need it for all feild like financial year, year,quarter,month.

hence i found a workaround by concatenating the fields with "/" delimiter and displayed it in the list box.

Like this :  FinancialYear &'/'& Year &'/'& Quarter &'/'&  MonthName As HierarchyDate


the below given is the screen shot of the drill down style calendar

Drilldown screen shot.PNG

but facing issues in sorting of FY years , will find out how to deal with this.

Thanks,

11 Replies
YoussefBelloum
Esteemed Contributor

Re: Hierarchy Calendar

Hi,

you need to show it using a hierarchy in what way ? on filters ? on dimensions on a chart ?

chandana_gowdar
Contributor II

Re: Hierarchy Calendar

Hi Youssef, I need to show it in Hierarchy in a Filter way.

YoussefBelloum
Esteemed Contributor

Re: Hierarchy Calendar

Can you show us the expected output please ?

on a listbox, you can do this (choose the operator - for your date field):

Capture.JPG?_ga=2.241771330.1745226637.1525256592-284371841.1525256592

chandana_gowdar
Contributor II

Re: Hierarchy Calendar

Hi Youssef ,

Your Suggested option donot work , as i need it for all feild like financial year, year,quarter,month.

hence i found a workaround by concatenating the fields with "/" delimiter and displayed it in the list box.

Like this :  FinancialYear &'/'& Year &'/'& Quarter &'/'&  MonthName As HierarchyDate


the below given is the screen shot of the drill down style calendar

Drilldown screen shot.PNG

but facing issues in sorting of FY years , will find out how to deal with this.

Thanks,

YoussefBelloum
Esteemed Contributor

Re: Hierarchy Calendar

You answered your question, with this method you need only one delimiter and you added it

to make an ascending sorting, you can try this:

uncheck only expression in the sorting and put this on ascending:

=Max(Date)

chandana_gowdar
Contributor II

Re: Hierarchy Calendar

This works thanks Youssef.

YoussefBelloum
Esteemed Contributor

Re: Hierarchy Calendar

you're welcome, good luck

chandana_gowdar
Contributor II

Re: Hierarchy Calendar

Thanks a Lot Youssef.

I just noticed that this list box is not allowing multiple selection.

for example if i select "Jan" in FY18 and select "Jan" in FY17 then the selection of FY18 will automatically get deselected.

the object's presentation is in <User Default > mode.

tried other presentation modes but those doesnt look good on UI.

Any ideas on this ??

Thanks

YoussefBelloum
Esteemed Contributor

Re: Hierarchy Calendar

did you try making selections and pressing CTRL button ?