Bar Chart Dimension Issue

[Anonymous]

Hello,

I am a beginner on QlikView, and i would to create a chart which shows the result of the 12 last "MaJ" from the "Maj" Selected (1 year period from the Maj selected) :

However my chart shows just the result of the MaJ selected:

(Here "STEASoF" = "MaJ")

The dimension:

And the Expression looks like:

Do you have an idea ?

Thanks for advance for your help,

Cocalero.

[swuehl]

I got lost ...

[sunny_talwar]

I think the attachment did not come through for some reason.

[Anonymous]

Stupid question: How can i post my sample please ?

[Anonymous]

Stupid question: How can i post my sample please ?

[sunny_talwar]

Step1:

Step2:

[Anonymous]

Thanks a lot, here my sample:

[sunny_talwar]

Something like this?

Expression

SUM({$<Job = {'Trader'}, AsOF = {$(=Max(AsOF)), $(=Max({<AsOF>}AsOF, 2)), $(=Max({<AsOF>}AsOF, 3))}>} STE)

Right now it just have set analysis for last three periods, but you can add the remaining 7 periods in your actual application.

[Anonymous]

Thanks for your response.

But I don't understand why "=Max({<AsOF>}AsOF, 3)" is always equal to 42369, "=Max({<AsOF>}AsOF, 2)" is always equal to 42398 too. Why it doesn't change with the selection of the AsOF.

Cocalero.

[swuehl]

Or using the numeric search:

SUM({$<Job = {'Trader'}, AsOF = {">=$(=AddMonths(Max(AsOF),-2))<=$(=Max(AsOF))"}>} STE)

[Anonymous]

It works perfectly !!

Thanks a lot