Discussion Board for collaboration related to Creating Analytics for QlikView.
We have a issue of using Function MonthName in MultiBox.
The sample data is as given below :-
Load * Inline [
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
MonthName(Date) AS MonthName
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.
In the example file which you had given, month selection works properly in both the multiboxes.
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.
It worked fine. I tried with 11.2 sr7.
What version of Qlik you use?
Is spanish version
My QV version is -
Consider upgrading it to 11.2 sr7
Check If that help.