Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Last value of column(x) group by dimension

In the picture below i want the following output as my result in the 7e column:

Arnhem: 8 (Delta)
Rotterdam: 1 (Delta)

I used the following expression in the 8e column: COUNT(TOTAL<Region>Actual-Budget)
In the 7e column I used this expression in the function 'FieldValue' and looks like this:
FieldValue('Delta',Count(TOTAL<Region>Actual-Budget))

Now I known that 'FieldValue' looks after the LOAD order and not on the value order of this chart.

My question is what for expression is needed to give me the right output??

error loading image

4 Replies
MVP
MVP

Last value of column(x) group by dimension

Hello,

Could you please elaborate on your criteria? Do you want to display the "8" because is the actual for Arnhem?

Regards.

Not applicable

Last value of column(x) group by dimension

My criteria is:

Last value of delta that is not null group by region.

So the result i want is 8 for Arnhem and 1 for Rotterdam.

Can you help me?

MVP
MVP

Last value of column(x) group by dimension

Hello,

The solution will be something like the following (with your own fields)

FirstSortedValue({< Actual = {'>0'} >} TOTAL <City> Actual, -MonthYear)


Without having a sample code, it's difficult to me to go further.

Hope that helps.

Not applicable

Last value of column(x) group by dimension

Your solution works fine, thank you!

Community Browser