topic Re: Formula that points to the last date in QlikView

Formula that points to the last date

danialier — Fri, 21 Feb 2014 13:08:55 GMT

Hello,

I have months written as follows: 201301 (January 2013), 201302 (February 2013), 201303,.......

Is there any formula when editing the expression that can refer to the last perfiod by default (this would be 201303 in the example above) ? Taking into account the way I write the perdios it should be a formula that points to the highest number.

Please help !

dani

Re: Formula that points to the last date

sunilkumarqv — Fri, 21 Feb 2014 13:10:51 GMT

Can more specfic what you trying to say?

Re: Formula that points to the last date

Fri, 21 Feb 2014 13:20:58 GMT

Dani,

You can do it either in the script to store your result into a variable,

or in the UI with FirstSortedValue(Month, -Month, 1)

Fabrice

Re: Formula that points to the last date

danialier — Fri, 21 Feb 2014 13:37:14 GMT

Yes, sorry. I need a formula that gives me the numbers of revenues for the last period (whatever is the last period).

Re: Formula that points to the last date

MK_QSL — Fri, 21 Feb 2014 13:39:58 GMT

Try...

1) =FirstSortedValue(Period,-Period)

2) =Date(Max(Date#(Period,'YYYYMM')),'YYYYMM')

Re: Formula that points to the last date

Fri, 21 Feb 2014 14:08:08 GMT

FirstSortedValue(Revenue, -Month, 1)

Fabrice