Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chandana_gowdar
Contributor II

Re: hierarchy calender

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

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

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

chandana_gowdar
Contributor II

Re: hierarchy calender

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

chandana_gowdar
Contributor II

Re: hierarchy calender

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

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

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

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

chandana_gowdar
Contributor II

Re: hierarchy calender

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

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

what reference are you looking for ?

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

chandana_gowdar
Contributor II

Re: hierarchy calender

Youssef , have u reverted with the updated qvw file ?

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

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

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

hierarchy.png