Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI,
In the example file which you had given, month selection works properly in both the multiboxes.
Regards,
Kaushik Solanki
In my PC runs OK, see the image
But I thinks better change the name or fields, because Date and Month are names reserved
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.
Try to change the names of fields Date & Month
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
Hi,
It worked fine. I tried with 11.2 sr7.
What version of Qlik you use?
Regards
ASHFAQ
Is spanish version
My QV version is -
Hi,
Consider upgrading it to 11.2 sr7
Check If that help.
Regards
ASHFAQ.