topic Re: Bar Chart Dimension Issue in QlikView

Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 08:27:43 GMT

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.

Re: Bar Chart Dimension Issue

Chanty4u — Wed, 30 Mar 2016 11:18:54 GMT

can u explain more?

what is expected output?

Re: Bar Chart Dimension Issue

swuehl — Wed, 30 Mar 2016 11:18:54 GMT

Maybe like

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

Re: Bar Chart Dimension Issue

sunny_talwar — Wed, 30 Mar 2016 11:19:12 GMT

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)

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 12:52:58 GMT

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.

Re: Bar Chart Dimension Issue

swuehl — Wed, 30 Mar 2016 12:56:06 GMT

Could you post a small sample QVW?

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:02:55 GMT

I am so sorry but i can't 😕

But i can post some Screenshots

Re: Bar Chart Dimension Issue

sunny_talwar — Wed, 30 Mar 2016 13:04:20 GMT

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

Re: Bar Chart Dimension Issue

swuehl — Wed, 30 Mar 2016 13:06:36 GMT

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.

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:22:10 GMT

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.

Re: Bar Chart Dimension Issue

swuehl — Wed, 30 Mar 2016 13:24:04 GMT

I got lost ...

Re: Bar Chart Dimension Issue

sunny_talwar — Wed, 30 Mar 2016 13:24:10 GMT

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

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:24:50 GMT

Stupid question: How can i post my sample please ?

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:25:07 GMT

Stupid question: How can i post my sample please ?

Re: Bar Chart Dimension Issue

sunny_talwar — Wed, 30 Mar 2016 13:29:34 GMT

Step1:

Step2:

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:31:48 GMT

Thanks a lot, here my sample:

Re: Bar Chart Dimension Issue

sunny_talwar — Wed, 30 Mar 2016 13:38:03 GMT

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.

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:49:04 GMT

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.

Re: Bar Chart Dimension Issue

swuehl — Wed, 30 Mar 2016 13:49:04 GMT

Or using the numeric search:

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

Re: Bar Chart Dimension Issue

Anonymous — Wed, 30 Mar 2016 13:52:38 GMT

It works perfectly !!

Thanks a lot