topic Re: Month Char in QlikView

Month Char

gautik92 — Fri, 25 Sep 2015 10:32:11 GMT

I have a bar chart with two expressions showing values for max month and max(Month)-variable

in legend i want to show the name of the month

how can i achieve this?

Now its show no of month

Re: Month Char

robert_mika — Fri, 25 Sep 2015 10:36:22 GMT

Did you try:

Presentation-Show Legend

Re: Month Char

nagarjuna_kotha — Fri, 25 Sep 2015 10:36:28 GMT

Hi Gowtham,

Can u share some sample data...?

Re: Month Char

gautik92 — Fri, 25 Sep 2015 10:38:44 GMT

not that.

I have legend lik this

but i want lik Dec for 12 and jun for 6

Re: Month Char

Digvijay_Singh — Fri, 25 Sep 2015 10:41:53 GMT

You can use calculated dim something like dual(monthname(Date),Month). Not sure though if that is needed.

Re: Month Char

gautik92 — Fri, 25 Sep 2015 10:43:30 GMT

am telling about expression legend

Re: Month Char

Gysbert_Wassenaar — Fri, 25 Sep 2015 10:43:58 GMT

The easiest way is to create a small inline table in the script first that creates the Month values as dual values that have both a text representation for display and the 'real' number value of the month:

LOAD dual(MonthName, MonthNumber) as Month INLINE [

January,1

February, 2

...etc

December, 12

];

Re: Month Char

simenkg — Fri, 25 Sep 2015 10:46:39 GMT

Perhaps something like:

Monthname(max(Date)) and monthname(Addmonths(max(Date),-variable))

Re: Month Char

gautik92 — Fri, 25 Sep 2015 10:49:45 GMT

PFA

Re: Month Char

stephenedberkg — Fri, 25 Sep 2015 10:58:10 GMT

dear gautik92

Try this

Current Month

upper(Date(Max({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Quarter=,Month=>}URDATE_Field),'MMM-YY'))

Last Month

upper(Date(Max({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID)-1)},Quarter=,Month=>}URDATE_Field),'MMM-YY'))

-1 instead of use your variable

Re: Month Char

gautik92 — Fri, 25 Sep 2015 11:03:44 GMT

It dint work Stephenedberkg‌

Re: Month Char

Fri, 25 Sep 2015 11:15:16 GMT

Following script will resolve

MapTable:

Mapping LOAD

RowNo() as MonthID,

Month(AddMonths((Today()),RowNo()+7)) as MonthName

AutoGenerate 12;

FactTable:

LOAD *, ApplyMap('MapTable',MonthID) as MonthName

Inline [

MonthID

];

Re: Month Char

gardenierbi — Fri, 25 Sep 2015 11:25:02 GMT

See attachment, do you mean something like this?

Re: Month Char

gautik92 — Fri, 25 Sep 2015 11:26:16 GMT

i askd for legends not dimesions

Re: Month Char

gardenierbi — Fri, 25 Sep 2015 11:30:18 GMT

Works the same! See attachment!

Re: Month Char

sasiparupudi1 — Fri, 25 Sep 2015 11:32:40 GMT

use the expressions

=Month(MakeDate(year(Today(1)),max(Month)))

and

=Month(MakeDate(year(Today(1)),max(Month)-1))

for your labels in your chart

hth

Sasi

Re: Month Char

gautik92 — Fri, 25 Sep 2015 11:32:56 GMT

Excellent!!!! Thanks GardenierBI