topic Current Month vs Previous Month Dif with Above() in QlikView

Current Month vs Previous Month Dif with Above()

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

Hi all,

I've created another discussion that is related to this subject:

current Month vs Previous Month

I was still not able to show the Value difference between current month and previous month in line chart.

When I put it a table it gives me the rigth values, but in a line char, it shows the wrong values.

Then I've found this discussion:

Above ( ) function in Line chart gives incorrect results‌

Using this expression that swuehl gave:

=aggr(

YourExpression

, YearField, MonthField)

I was able to put the correct values.

But I still can´t show the right values for the first months: jan-2016 and jan-2017, and the last month: dez-2016.

I´ve attached my sample app. ( see Sheet 1)

Any thoughts?

Thanks in advanced,

Sílvia

Re: Current Month vs Previous Month Dif with Above()

swuehl — Tue, 14 Feb 2017 11:56:12 GMT

Aggr() by default sorts its dimensional values by load order.

I think you need to sort your dimensional values in chronologic correct order, either in the load script, or using

The sortable Aggr function is finally here!

Re: Current Month vs Previous Month Dif with Above()

Anonymous — Tue, 14 Feb 2017 12:29:47 GMT

Thanks for your reply Stefan,

I've tried with the sortable aggr function in QlikView 12 and it works perfectly.

I've tried the same thing in QlikView 11 and it did not work? Is this solution only available for Qlik View 12?

Re: Current Month vs Previous Month Dif with Above()

swuehl — Tue, 14 Feb 2017 14:44:59 GMT

Yes, I think it's only available for QlikSense and QV12, though I am not 100% sure if maybe it has been also added to latest SR of QV. It's a pretty new feature.

Re: Current Month vs Previous Month Dif with Above()

Anonymous — Tue, 14 Feb 2017 15:12:18 GMT

It is indeed.

Thanks for your help

Sílvia