Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

girish_talele
Contributor

MonthName Function Issue in MultiBox

Dear Experts,

We have a issue of using Function MonthName in MultiBox.

The sample data is as given below :-

Data1:

Load * Inline [

Date, OrdNo

01.04.2014, Ord 1

02.04.2014, Ord 2

03.04.2014, Ord 3

11.05.2014, Ord 4

24.05.2014, Ord 5

24.06.2014, Ord 6

25.06.2014, Ord 7

30.07.2014, Ord 8

31.07.2014, Ord 9

01.08.2014, Ord 10

02.08.2014, Ord 11

03.08.2014, Ord 12

];

//=============================================

Data2:

Load

  *,

  MonthName(Date) AS MonthName

Resident Data1;

Drop Table Data1;

//=============================================

If we skip second resident table (Data2) & generate MonthName in MultiBox & if we select SINGLE date in Result Table in the MultiBox is showing value as - "Apr-2014" (refer attached file & snap).

Please suggest how to tackle this issue.

Capture.JPG.jpg

Tags (2)
10 Replies

Re: MonthName Function Issue in MultiBox

HI,

In the example file which you had given, month selection works properly in both the multiboxes.

Regards,

Kaushik Solanki

ecolomer
Honored Contributor II

Re: MonthName Function Issue in MultiBox

In my PC runs OK, see the image

fechas.png

But I thinks better change the name or fields, because Date and Month are names reserved

girish_talele
Contributor

Re: MonthName Function Issue in MultiBox

Dear Kaushik & Enrique,

Thanks for looking into.

It's strange, might be some document or other property's setting issue.

Do you have any idea.

ecolomer
Honored Contributor II

Re: MonthName Function Issue in MultiBox

Try to change the names of fields Date & Month

Not applicable

Re: MonthName Function Issue in MultiBox

screenshot.png

Looks like an issue to me as well, if we select any value in the Data then it defaults to April or else it is showing as Aug when we select from first multibox.

Thanks,

Sai

Re: MonthName Function Issue in MultiBox

Hi,

It worked fine. I tried with 11.2 sr7.

What version of Qlik you use?

Regards

ASHFAQ

ecolomer
Honored Contributor II

Re: MonthName Function Issue in MultiBox

Is spanish version

QV_lic.png

girish_talele
Contributor

Re: MonthName Function Issue in MultiBox

My QV version is -

Capture.JPG.jpg

Re: MonthName Function Issue in MultiBox

Hi,

Consider upgrading it to 11.2 sr7

Check If that help.

Regards

ASHFAQ.

Community Browser