date divide

[#1]

hi guys!

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?

[tresesco · Accepted solution]

May be like attached sample?

[nilesh_gangurde]

Hi,

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,

          count

FROM

C:\Users\atacan.simsek\Desktop\test.xlsx

(ooxml, embedded labels, table is Sheet1);

then in your dimension tab. say "Add Calculated Dimension."

and add below mentioned script

=MonthName(date)

Then in your expression take:

Sum(Count)

Hope this will help;

-Nilesh

[#4]

thnx mate!

[#5]

thnx mate!