topic Re: Hierarchy Calendar in QlikView

Hierarchy Calendar

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Hierarchy Calendar

YoussefBelloum — Wed, 02 May 2018 10:17:21 GMT

Hi,

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

Re: Hierarchy Calendar

Anonymous — Wed, 02 May 2018 10:19:52 GMT

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

Re: Hierarchy Calendar

YoussefBelloum — Wed, 02 May 2018 10:26:27 GMT

Can you show us the expected output please ?

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

Re: Hierarchy Calendar

Anonymous — Wed, 02 May 2018 11:34:50 GMT

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

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

Thanks,

Re: Hierarchy Calendar

YoussefBelloum — Wed, 02 May 2018 11:39:35 GMT

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)

Re: Hierarchy Calendar

Anonymous — Wed, 02 May 2018 11:43:01 GMT

This works thanks Youssef.

Re: Hierarchy Calendar

YoussefBelloum — Wed, 02 May 2018 11:44:38 GMT

you're welcome, good luck

Re: Hierarchy Calendar

Anonymous — Wed, 02 May 2018 11:52:56 GMT

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

Re: Hierarchy Calendar

YoussefBelloum — Wed, 02 May 2018 11:57:25 GMT

did you try making selections and pressing CTRL button ?

Re: Hierarchy Calendar

Anonymous — Wed, 02 May 2018 12:38:31 GMT

ctrl works but i want an automatic option.

any ideas ?

Re: Hierarchy Calendar

YoussefBelloum — Wed, 02 May 2018 12:43:59 GMT

I don't think there is another alternative in this scenario because when you make a selection, you're selecting unique Date value which correspond only to that date, everything else goes grey I suppose, each selection will override the previous one..