Discussion Board for collaboration on QlikView Scripting.
I have a csv data source containing Date column in the format 'DD-MMM-YY eg: 22-Oct-15.
I want to display this dates in the format MMM-YYYY in multibox.
I tries this by using MonthName() function but couldn't find any solution.
Please help me out. Attached is the csv for your reference.
Thanks in advance
just use function date
I tried using this but couldn't find the exact solution.
I am not getting any item in the list box.
use expression in multibox
See if this helps:
LOAD [Planned Completion Date],
[Revised Completion Date],
MonthName([Planned Completion Date]) as Test1,
MonthName([Revised Completion Date]) as Test2,
Date([Planned Completion Date], 'MMM-YYYY') as Test3,
Date([Revised Completion Date], 'MMM-YYYY') as Test4
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Use below as an expression in MultiBox or ListBox
Date(Date#([Planned Completion Date],'DD-MMM-YY'),'MMM-YYYY')
Why are you using Date# function in your expression.
As planned completion date field is number format.
Is there any specific reason to use Date#.........
Refer the below link.you will get an idea.
The Date Function
I tries using the above expression but it didn't work in my case.
I am getting a empty multibox