topic Re: Need Help in QlikView

Need Help

paulwalker — Tue, 14 Jul 2015 03:30:59 GMT

Hi Community,

I have one issue in Expression Label..

In my bar chart comparing Current month and Previous Month data.

in label i have used Max(Month) but it showing Number... I want to show Month name..

based on selection i want to change...

Thanks in advance..............

Re: Need Help

settu_periasamy — Tue, 14 Jul 2015 03:36:00 GMT

Try,

=MonthName(Max(Month))

Re: Need Help

paulwalker — Tue, 14 Jul 2015 03:43:23 GMT

Hi Settu,

Thanks for response...

it's showing jan 1900

Re: Need Help

paulwalker — Tue, 14 Jul 2015 03:49:13 GMT

Hi All,

=If(Max(Month)=12, 'Dec',

If(Max(Month)=11, 'Nov', and so on......

This expression works fine............

any other solution..????

Re: Need Help

settu_periasamy — Tue, 14 Jul 2015 03:49:57 GMT

Sorry,

Try this,

Month(Max(Month))

Re: Need Help

PrashantSangle — Tue, 14 Jul 2015 04:03:25 GMT

Hi,

if you have to different field for month and year then try

max(Month) &' '& max(Year)

or create a monthyear field in script level and use it in your front end.

Regards

Re: Need Help

maxgro — Tue, 14 Jul 2015 04:54:31 GMT

left(MonthName(Max(Month)),3)

date(Max(Month),'MMM')

Re: Need Help

Anonymous — Tue, 14 Jul 2015 05:25:47 GMT

Hi Paul ,

Check your default monthname settings .

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Thanks

Re: Need Help

Tue, 14 Jul 2015 05:37:12 GMT

Hi Paul,

Try like this way:

Date(Max(Month), 'MMM')

Ramya.

Re: Need Help

paulwalker — Tue, 14 Jul 2015 13:52:00 GMT

HI All,

Thanks for reply everyone..

In expression label i want to show Month name and previous month name

PFA,

Re: Need Help

settu_periasamy — Tue, 14 Jul 2015 14:22:02 GMT

Hi,

like the below snapshot.

PFA.

Re: Need Help

paulwalker — Tue, 14 Jul 2015 14:23:22 GMT

I got it..

Thanks everyone..

CurrentMonth:

=left(MonthName(Max(DDMonthYear)),3)

Previous Month:

=Date(addmonths(max(DDMonthYear), -1),'MMM')

Re: Need Help

paulwalker — Tue, 14 Jul 2015 14:29:54 GMT

Thanks for help Settu..

I hit Correct Answer............

Re: Need Help

Anonymous — Tue, 14 Jul 2015 14:33:36 GMT

Although it is resolved - I'd recommend to use date/time functions rather than string functions. That is, the current month should be simple:

=date(Max(DDMonthYear),'MMM')

Re: Need Help

paulwalker — Wed, 15 Jul 2015 09:05:42 GMT

Yes Michael,

Your right....