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