Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chandana_gowdar
Contributor II

Re: hierarchy calender

Hi Youssef ,

Yes i see that you have attached the qvw file , i have also implemented that .

just that the h_date column is not linked to the data.

I was asking for the option to link the h_date list box to the table implemented in the dashboard.

any thoughts on that  ??

Thanks

chandana_gowdar
Contributor II

Re: hierarchy calender

I couldn't see the attached file.. some how now it is visible.

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

it is ok for you ??

chandana_gowdar
Contributor II

Re: hierarchy calender

Hi Youssef,

Yes seems like this is serving the purpose, but just one thing about the Financial year.

In the file which you have implemented the Year is only considered as the financial year. i.e like FY : Num(Year)

but in the data which i have , i have the column data for Financial year.

So i want to use that in the hierarchy , as given in the below order.

Financial Year -->

                         Year -->

                               Quarter -->

                                       Month-->

                                             Date.

I think this should be modified in the scripting only, kindly help me out in achieving this.

Thanks

chandana_gowdar
Contributor II

Re: hierarchy calender

attached is the data and the H Calendar implementation as suggested by you.

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

try this before

hierarchy.png

on you code, just change the red parts to your actual characters (Financial year)

chandana_gowdar
Contributor II

Re: hierarchy calender

not the characters , i need the values of financial year column.

In the below given code

LOAD DISTINCT num(Year) as Child,

'FY: '&num(Year) as Parent

RESIDENT data;

LOAD DISTINCT 'FY: '&num(Year) as Child,

'-' as Parent

RESIDENT data;

in the cold and underlined, we are concatenating FY with the values of Year .. right?

here i donot want to concatenate , i just want to call the Financial year column.

and i have changed it to as given below :

LOAD DISTINCT num(Year) as Child,

FinancialYear as Parent

RESIDENT data;

LOAD DISTINCT FinancialYear as Child,

'-' as Parent

RESIDENT data;

This seems to be working .

chandana_gowdar
Contributor II

Re: hierarchy calender

Thanks a Tonn for this Youssef

YoussefBelloum
Esteemed Contributor

Re: hierarchy calender

you're welcome, good luck

bvssudhakar
Contributor II

Re: hierarchy calender

Hi Youssef,

This is perfect

Thank you