7 Replies Latest reply: Feb 22, 2013 4:00 AM by Michiel Kuiper RSS

Chart show last 4 weeks of an selected period

Michiel Kuiper

Hello,

 

I have a qlikview table with period data like:  PeriodID - Year - Quarter - Period -  Week

 

PeriodeID: Identical Key

Year: PeriodYear

Quarter: PeriodeQuarter (4 quarters in one year)

Period: Each period is 4 weeks (13 periods in one year)

Week: the weeknumber (52 weeks in one year)     

 

An another tables adds some financial information the PeriodeID.

This tables had an relation with the Period tabel by PeriodeID.

 

In my Qlikview file i would like to show to charts:

One chart with a sum by periode, so i see max 13 periods in the chart

One chart wich show the 4 weeks (Period) of the max (highest) period selected.

 

For example:

I selected period 1 and 2 of the year 2012, so this contains the weeks 1, 2, 3, 4, 5, 6, 7 and 8 of 2012

In the chart i would like to see the weeks 5, 6, 7 and 8 becease the highest selected period is 2 and this contains the weeknumbers 5, 6, 7 and 8.

 

Please can you help me?

 

I think it is not that dificult but i can't get it!

 

Thanks in advance