Discussion Board for collaboration on QlikView Scripting.
I need to convert " 200011" to Year and Month Format like this " Nov 2000".
I tried this
but it not working. Is there any way to do this.
Go to Solution.
Try date(date#('200011','YYYYMM'),'MMM YYYY')
You need to use date#() to convert the string into a date and than use date() get the desired format:
Also see the examples in the Qlikview Manual ...
Hope that helps!
See the attached file .
I have done a logical change and scripting in script of the qvw.
Hope it help you,
You may also find this link usefull (I know did) http://community.qlik.com/docs/DOC-3102
Thankyou all.. Everyone on the same line...