topic Re: MonthName Function Issue in MultiBox in QlikView

MonthName Function Issue in MultiBox

girish_talele — Sat, 16 Aug 2014 05:07:26 GMT

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.

Re: MonthName Function Issue in MultiBox

kaushiknsolanki — Sat, 16 Aug 2014 05:26:43 GMT

HI,

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

Regards,

Kaushik Solanki

Re: MonthName Function Issue in MultiBox

ecolomer — Sat, 16 Aug 2014 05:37:10 GMT

In my PC runs OK, see the image

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

Re: MonthName Function Issue in MultiBox

girish_talele — Sat, 16 Aug 2014 06:06:59 GMT

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.

Re: MonthName Function Issue in MultiBox

ecolomer — Sat, 16 Aug 2014 06:56:39 GMT

Try to change the names of fields Date & Month

Re: MonthName Function Issue in MultiBox

Sat, 16 Aug 2014 14:38:27 GMT

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

ashfaq_haseeb — Sun, 17 Aug 2014 06:20:44 GMT

Hi,

It worked fine. I tried with 11.2 sr7.

What version of Qlik you use?

Regards

ASHFAQ

Re: MonthName Function Issue in MultiBox

ecolomer — Sun, 17 Aug 2014 06:26:38 GMT

Is spanish version

Re: MonthName Function Issue in MultiBox

girish_talele — Mon, 18 Aug 2014 04:20:40 GMT

My QV version is -

Re: MonthName Function Issue in MultiBox

ashfaq_haseeb — Mon, 18 Aug 2014 05:15:22 GMT

Hi,

Consider upgrading it to 11.2 sr7

Check If that help.

Regards

ASHFAQ.

Re: MonthName Function Issue in MultiBox

ecolomer — Mon, 18 Aug 2014 05:56:56 GMT

I agree with Ashfaq Mohammed