topic Re: QlikView Table Chart use dimension in expression in QlikView

QlikView Table Chart use dimension in expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: QlikView Table Chart use dimension in expression

sunny_talwar — Thu, 27 Apr 2017 10:54:38 GMT

Check out the attached

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

Re: QlikView Table Chart use dimension in expression

Anonymous — Thu, 27 Apr 2017 10:56:50 GMT

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

Re: QlikView Table Chart use dimension in expression

sunny_talwar — Thu, 27 Apr 2017 10:59:10 GMT

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

Re: QlikView Table Chart use dimension in expression

Anonymous — Thu, 27 Apr 2017 11:10:36 GMT

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

Re: QlikView Table Chart use dimension in expression

sunny_talwar — Thu, 27 Apr 2017 11:22:30 GMT

See if the attached works

Re: QlikView Table Chart use dimension in expression

Anonymous — Thu, 27 Apr 2017 13:25:29 GMT

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€:

Re: QlikView Table Chart use dimension in expression

sunny_talwar — Thu, 27 Apr 2017 13:26:46 GMT

Need to select in AsOfFase