topic Re: Format number to month name in chart in QlikView

Format number to month name in chart

daniel1990xyz — Mon, 21 Aug 2017 10:13:31 GMT

I would like to create a slider chart to select a month name (jan->dez) with a static step of 1. So it should not be possible to move the arrow between 2 month. The selected month should be written in a variable. Therefore I have

created a slider object,
defined a variable,
set the Min Value to "1",
set the max value to "12",
set the Static step to "1"

The slider shows me now the values from 1 to 12 and it works as I want so for, but the values will be presented as numbers. How can I format the numbers (1 to 12) as the month names? Is it possible to format the numbers as the month name in the chart tab "number"?

I tried to use something like "MMM" or "##.MMM.####" but the number will be always interpreted as day instead of month. And "#" could not be used as a placeholder.

Thanks for any help in advance.

Re: Format number to month name in chart

vinieme12 — Mon, 21 Aug 2017 10:15:20 GMT

=month(makedate(year(today()), YOURVARIABLE,1))

Re: Format number to month name in chart

Bala_s — Mon, 21 Aug 2017 10:20:19 GMT

Share ua sample data.

Regards,

Bala

Re: Format number to month name in chart

daniel1990xyz — Mon, 21 Aug 2017 10:35:06 GMT

I think this will not solve my problem. At the moment my slider looks like this:

I would like to format the number to month names. So the slider should show "Jan" instead of 1 and so one.

Re: Format number to month name in chart

Kushal_Chawda — Mon, 21 Aug 2017 10:48:55 GMT

create inline table in your model

LOAD *,Dual(MonthName,Month) as DualMonth Inline [

Month,MonthName

1,Jan

2,Feb

3,Mar

4,Apr

5,May

6,Jun

7,Jul

8,Aug

9,Sep

10,Oct

11,Nov

12,Dec

];

Use DualMonth field in slider instead variable

Re: Format number to month name in chart

daniel1990xyz — Mon, 21 Aug 2017 11:41:44 GMT

Thanks for your reply.

Are there any possibilities to keep the variable? So that the selected value in the slider will be written in a variable?

Re: Format number to month name in chart

vinieme12 — Mon, 21 Aug 2017 11:46:30 GMT

Nope, can't do with a variable

You can retrieve the selected value from the Month field

Re: Format number to month name in chart

pradosh_thakur — Mon, 21 Aug 2017 12:12:14 GMT

hi daniel

kushal is right. This is the easiest way to do it. i will suggest these steps.

create inline table in your model

LOAD *,Dual(MonthName,Month) as DualMonth Inline [

Month,MonthName

1,Jan

2,Feb

3,Mar

4,Apr

5,May

6,Jun

7,Jul

8,Aug

9,Sep

10,Oct

11,Nov

12,Dec

];

2:
use DualMonth as your filedname in the slider

open variable overview and create a new variable v1 and in the definition =GetFieldSelections(DualMonth)

the value you selected in the slider will be written to the variable v1.

regards

Pradosh

Re: Format number to month name in chart

Kushal_Chawda — Mon, 21 Aug 2017 12:45:42 GMT

You can create the variable on front end and put the below expression in variable

=num(only(DualMonth))

Re: Format number to month name in chart

daniel1990xyz — Tue, 22 Aug 2017 06:51:08 GMT

Hi Pradosh,

Thank you for your explanation and the sample file. With this information I was able to solve my issue.

regards

Daniel