Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time Hierarchy not working at all level

HI ALL,

I have simple TIme table.Which contains below information.

TableName:DimTime

Timekey          Year     Quarter      MOnth DayofMonth

20111014      2011      4           October      14

20111013     2011     4          October           13

20110905     2011     3          September         5

20100804     2010     3          August           4

Fact Table:Income

Timekey      Income

20111014     100

20111013     200

20110905     200

20110804     250

In qlikview , I would like to see

2011

     October

               13

               14

     September

               05

2010

     August

               04

If I select Year 2011 , My fact table should show

Timekey       Income

20111014     100

20111013     200

20110905     200

If i select October month from 2011 , my fact table should show

Timekey      Income

20111014     100

20111013     200

If I select 2011 -October-13 , my fact table should show

Timekey     Income

20111013     200

Can some one please tell me , how to achieve this?

0 Replies