QlikView Table Chart use dimension in expression

[Anonymous]

Hi guys,

I've attached a sample example and its excel file data.

In my table Table with Current and Previous I want in column Value Prev Month, the value of the previous month.

Example:

In second row MonthYear is ago-2016, so I want in Value Prev Month the value of jul-2016.

In column Expression with values, I'd put the expression that is being constructed by qlik, but I can't seem to understand why it doesn't show the month year.

Is it possible to use the value of dimension of the same row, right?

How?

Thanks in advanced,

Sílvia

[sunny_talwar]

Check out the attached

Above(Sum({<MonthYear>}Value)) * Avg(1)

[Anonymous]

Hi Sunny,

Thanks for your answer.

Can I achieve the same but without the Above() function?

I only want the MonthYear -1 to matter.

Thanks,

Sílvia

[sunny_talwar]

Why without Above() function??? May be use The As-Of Table approach?

[Anonymous]

I don't want to use the above because:

Example:

If I add a new dimension, Fase.

When I filter for example Fase = P.

With the Above function() I lost the value for jul-2016.

See image below:

But I do need to present that value.

So thats why want I want to keep my choice in month year.

So that in Value Prev Month, it shows the value for jul-2016. even though that month is not in fase P

[sunny_talwar · Accepted solution]

See if the attached works

[Anonymous]

Hi Sunny,

I don't have access to the script, so I can't use that solution.

Anyway, I tried your solution in the sample app but it doesn't seem to work.

When I choose Fase = P, the first month of that fase is ago-2016, and in column refering to Value Prev Month it shows 0€:

[sunny_talwar]

Need to select in AsOfFase