topic How to create a Last Month label? in QlikView

How to create a Last Month label?

jim_chan — Thu, 07 Apr 2016 08:30:24 GMT

Hi guys,

I have created the tablebox, now i need that label to state as Last Month Jan/Feb/Mar..... so on.

For example, if i have click on April, that column will show March figure, i need the label to be Last Month March.

I have below expression. but didnt seem to work.

='Last Month' & Month(addmonths(max(Month) ,- 1))

Rgds,

Jim

kaushiknsolanki — Thu, 07 Apr 2016 08:34:46 GMT

Hi,

You can try this.

='Last Month' & Month(addmonths(max(Date) ,- 1))

Regards,

Kaushik Solanki

Chanty4u — Thu, 07 Apr 2016 08:35:52 GMT

try wit max date

='Last Month' & Month(addmonths(max(Date) ,- 1))

Chanty4u — Thu, 07 Apr 2016 08:37:28 GMT

or else

='Last Month' & Num(Month([ Date]))-1)

LastMonth = max(Month)-1

and then:

='Last Month' & sum({$<Month={$(LastMonth)} >} Sales)