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.

[Chanty4u]

can u explain more?

what is expected output?

[swuehl]

Maybe like

Sum({$<Job = {'Trader'}, STEAsOf = {">=$(=Num(AddMonths(MaJ,-12)))"}, MaJ= >} STE)

[sunny_talwar]

What format does you STEASoF comes in? Date or number?

If it is number, then try this:

Sum({<Job = {'Trader'}, STEASoF = {"$(='>=' & (Max(STEASoF) - 12) & '<=' & Max(STEASoF))"}>} STE)

If it is date format, then try this:

Sum({<Job = {'Trader'}, STEASoF = {"$(='>=' & Date(Max(STEASoF) - 12), 'DateFieldFormatHere') & '<=' & Date(Max(STEASoF), 'DateFieldFormatHere'))"}>} STE)

[Anonymous]

Hello,

Thanks for your help but it doesn't work 😕

I tried this Expression:

My STEAsOF looks like that:

I would like to have the results of the 12 last STEAsOf from my STEAsOf Selected on my Chart:

Cocalero.

[swuehl]

Could you post a small sample QVW?

[Anonymous]

I am so sorry but i can't 😕

But i can post some Screenshots

[sunny_talwar]

few sample rows of data? not even real data, may be some made up dummy data

[swuehl]

Why not?

Anyway, have you tried my suggested expression?

Your STEAsOf values are essentially Month end dates, so you should use AddMonths() function or AddYears() to return a date 12 months back.

And you might also need to clear other user selections in calendar fields to prevent an incompatible set. Just as I did with MaJ field.

[Anonymous]

Here a QlikView test where there is a chart staked, with 3 different AsOF.

I would like to show 2 AsOf into the dimension: the AsOf Selected and the previous one.

Thanks for advance,

Cocalero.