Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If i select October month from 2011 , my fact table should show
If I select 2011 -October-13 , my fact table should show
Can some one please tell me , how to achieve this?