Display an evolution by time and dimension

marakud971 — Mon, 23 Mar 2020 17:06:40 GMT

Good morning all,

I am contacting you to request your assistance.

Indeed, I have a request from a client that I cannot manage to implement.

He would like to compare elements of a dimension over time (Year, Semester, Quarter, Month, Week, Days) by a dimension in Year-to-Year mode.

To understand i'll give you an example.

I have a dimension with several values.
In the same graph and for each value of the dimension,
I would like to see the evolution of the measure by Semester (or Quarter or Month or Week or Days) and that for the year N and N-1.

If my dimension has 3 values, in total I should have with 6 values.
3 for year N and 3 for year N + 1.
And all this in a the same line graph.

Thank you a lot.

Have a nice day

Re: Display an evolution by time and dimension

Taoufiq_Zarra — Mon, 23 Mar 2020 21:26:24 GMT

a version is attached in this post

for category A and year 2020 the syntax will be :

sum({<OPERATEUR={'A'},ANNEE={"$(=Max(ANNEE))"}>} NB)

topic Re: Display an evolution by time and dimension in QlikView

Display an evolution by time and dimension

Re: Display an evolution by time and dimension