topic Chart - to plot the same chart for different time periods in QlikView

Chart - to plot the same chart for different time periods

Mon, 29 Oct 2012 09:47:31 GMT

Hey,

I have the following chart:

- Dimension: =class(Wert_niO, 0.001)

- Expression: count(Wert_niO)

But the data that I plot depends also on the period of time that I choose. I would like to choose 2 different periods and plot 2 times the same chart (in one chart if its possible). The idea is to compare easily the lines of october and september, for example.

Thank you very much!!!!!!!!!!!

Eduardo

Re: Chart - to plot the same chart for different time periods

Mon, 29 Oct 2012 09:57:12 GMT

Hi,

You can try to add two expressions. One for september and one for october. This is to plot 2 periods in a chart.

Use count({<Month = {'Sep'}>} Wert_niO)

count({<Month = {'Oct'}>} Wert_niO)

Regards,

Janzen

Re: Chart - to plot the same chart for different time periods

Mon, 29 Oct 2012 10:28:33 GMT

Hey,

I forgot to tell you thawt I have 2 Dimensions (class(Wert, 0.001) and LinieWert). The second dimension allows me to plot 4 Lines, because I have 4 columns with information (I used Crosstable in my skript).

I tried to add "Month" as dimension but if I put it in second position than, I cannot plot 8 lines (4 for August and 4 for Sept for example). I just plot 2 lines (Aug and Sept).

How can I solve this problem??

Thank you for your time!!!!!

Eduardo

Re: Chart - to plot the same chart for different time periods

Gysbert_Wassenaar — Mon, 29 Oct 2012 11:32:38 GMT

Create a calculated dimension: LinieWert&'-'&Month and use that instead of Month and LinieWert

Re: Chart - to plot the same chart for different time periods

Mon, 29 Oct 2012 11:58:23 GMT

Thank you!!! It's jut what I needed!

Eduardo