Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to convert " 200011" to Year and Month Format like this " Nov 2000".
I tried this
=
Date# (01012001, 'MMM YYYY')but it not working. Is there any way to do this.
Thanks,
Selva
Try date(date#('200011','YYYYMM'),'MMM YYYY')
Try date(date#('200011','YYYYMM'),'MMM YYYY')
try this
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:
date(date#(200011,'YYYYMM'),'MMM YYYY')
Also see the examples in the Qlikview Manual ...
Hope that helps!
Regards,
Florian
Selva,
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...