topic Re: hierarchy calender in QlikView

hierarchy calender

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

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

Re: hierarchy calender

YoussefBelloum — Tue, 15 May 2018 14:27:32 GMT

Hi,

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

Re: hierarchy calender

Anonymous — Wed, 16 May 2018 06:17:28 GMT

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.

Thanks

Re: hierarchy calender

YoussefBelloum — Wed, 16 May 2018 08:10:42 GMT

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 ?

Re: hierarchy calender

Anonymous — Wed, 16 May 2018 10:30:39 GMT

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

Re: hierarchy calender

YoussefBelloum — Wed, 16 May 2018 11:59:52 GMT

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 ?

Re: hierarchy calender

Anonymous — Wed, 16 May 2018 12:17:04 GMT

Hi ,

Here It is , Find the attached

Thanks

Re: hierarchy calender

YoussefBelloum — Wed, 16 May 2018 15:33:11 GMT

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

Re: hierarchy calender

Anonymous — Thu, 17 May 2018 09:58:41 GMT

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

Re: hierarchy calender

YoussefBelloum — Thu, 17 May 2018 10:02:19 GMT

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

Re: hierarchy calender

Anonymous — Thu, 17 May 2018 10:06:40 GMT

yes please help me connecting to the data.

and also when i connected to my actual data as mentioned in the excel.

the data format is mm/dd/yyyy in the data and i used your "Date(Date#(Date,'MM/DD/YYYY'),'MM.DD.YYYY') as Date" formula to convert it.

somehow the date is not getting converted and coming up on the canvas..

Thanks

Re: hierarchy calender

YoussefBelloum — Thu, 17 May 2018 10:12:15 GMT

my biggest problem was trying to convert your date...

Also, I wasn't able to use a date field separated by / It only worken using date field separated by .

like this DD.MM.YYYY

Like I already said, it is the first time I use hierarchy, so I don't master the technique at all.

try to follow the steps and re-read the help.. if you're stuck I'll try to tag experts here

Re: hierarchy calender

Anonymous — Thu, 17 May 2018 14:20:09 GMT

I have some how managed to convert the data format in the source file itself , and the data in the hierarchy calender is also reflecting in the list box.

now i need to know how to link the table to the table data for it to filter/reflect on the selection of entries in the h_date list box.

any inputs form you would be really a great help.

Thanks

Re: hierarchy calender

Anonymous — Fri, 18 May 2018 12:00:56 GMT

Hi Youssef,

Could you please help me connect h_date to the data.

I am stuck here and this is really urgent, i will be really great full if u suggest on this

Thanks

Re: hierarchy calender

YoussefBelloum — Fri, 18 May 2018 12:43:38 GMT

Chandana, I'm on several threads simultaneously.. I'll take a look and hopefully I'll get back to you with a solution..

Re: hierarchy calender

YoussefBelloum — Fri, 18 May 2018 12:58:39 GMT

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

Re: hierarchy calender

Anonymous — Fri, 18 May 2018 13:06:18 GMT

i don't see any reference here Youssef , mention the reference which u are asking me to refer.

Re: hierarchy calender

YoussefBelloum — Fri, 18 May 2018 13:24:07 GMT

what reference are you looking for ?

I've connected the data table to the hierarchy calendar table, there is something missing ?

Re: hierarchy calender

Anonymous — Fri, 18 May 2018 13:32:23 GMT

Youssef , have u reverted with the updated qvw file ?

if yes then i guess you have forgotten to attach it may be.

Re: hierarchy calender

YoussefBelloum — Fri, 18 May 2018 13:36:46 GMT

Do you see that I've attached a document ? because I'm experiencing some bugs since this morning on the community..