This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a date dimension like and I would like to show it on my graph as month based...I dont wanna go back to database side and I want to edit it on qlikview....Is there any solution?
May be like attached sample?
View solution in original post
First, your date is in text formate you have to convert it into date formate; use following code for the same.
LOAD date(date#(date,'DD-MM-YYYY')) as date,
(ooxml, embedded labels, table is Sheet1);
then in your dimension tab. say "Add Calculated Dimension."
and add below mentioned script
Then in your expression take:
Hope this will help;