topic Issue with set analysis in QlikView

Issue with set analysis

Mon, 06 Sep 2010 18:14:18 GMT

Hi,

I can't figure out the good expression to this issue.

I have a table with

2 dimensions : Year & Month each in 2 separates fields

1 variable : Sale

I'd like to display a plot-chart with

Dimension : Year & Month . For this I use monthname(makedate(Year, Month))

Expression : I want to calculate the evolution from the previous year and for the same month

For example, in Aug 08, my calculation must give Sales in Aug 08 / Sales in Aug 07

My question is how to write the good expression for the denominator with my 2 sepatates fields Year & Month

Thanks again for your help and your time.

JJJ

Issue with set analysis

Tue, 07 Sep 2010 16:36:33 GMT

Any help, pls

Issue with set analysis

johnw — Tue, 07 Sep 2010 23:23:41 GMT

I suggest that you combine the Month and Year together into a real field. Calculated dimensions can be slow. They also would be rather complicated to use with my suggested solution, which is to handle it like in the attached file.