topic Re: Creating a Max date with a Text date in QlikView

Creating a Max date with a Text date

rido1421 — Fri, 12 Dec 2014 12:11:58 GMT

Hi There

I have a text date and I would like to create an Expression label showing the previous months name

for my current month its simple just [Month Abbrev] = 'Oct'

now I have a column for the previous months data and need to create a label that will be dynamic.

what will the easiest way to create this "[Month Abbrev]-1 " label be?

Thanks in advance

MK_QSL — Fri, 12 Dec 2014 12:17:22 GMT

Dual(Date(Date#(Month,'MMM')-1,'MMM'),Date(Date#(Month,'MMM')-1,'MM')) as PreviousMonth

its_anandrjs — Fri, 12 Dec 2014 12:25:18 GMT

Try this

=Month( AddMonths( max([Month Abbrev]) ,-2 ) )

Regards

Anand

rido1421 — Fri, 12 Dec 2014 12:33:49 GMT

Hi Anand

I had tried that expression ... it doesnt seem to work Month Abbrev is a text... would Max(Month Abbrev) work?

its_anandrjs — Fri, 12 Dec 2014 12:37:25 GMT

Ok then try this way first convert to the Date format of month

=Month( AddMonths( max(Date#(TextMonth,'MMM')) ,-1 ) )

And

=Month( AddMonths( max(Date(Date#(TextMonth,'MMM'),'MMM')) ,-1 ) )

Regards

Anand

rido1421 — Fri, 12 Dec 2014 12:52:29 GMT

This works great also

Thank you