Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
girish_talele
Creator
Creator

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

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ecolomer
Master II
Master II

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
Creator
Creator
Author

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
Master II
Master II

Try to change the names of fields Date & Month

Not applicable

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

ashfaq_haseeb
Champion III
Champion III

Hi,

It worked fine. I tried with 11.2 sr7.

What version of Qlik you use?

Regards

ASHFAQ

ecolomer
Master II
Master II

Is spanish version

QV_lic.png

girish_talele
Creator
Creator
Author

My QV version is -

Capture.JPG.jpg

ashfaq_haseeb
Champion III
Champion III

Hi,

Consider upgrading it to 11.2 sr7

Check If that help.

Regards

ASHFAQ.