topic Re: date divide in QlikView

date divide

Tue, 07 Jan 2014 11:44:59 GMT

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?

Re: date divide

tresB — Tue, 07 Jan 2014 11:48:31 GMT

May be like attached sample?

Re: date divide

nilesh_gangurde — Tue, 07 Jan 2014 11:52:54 GMT

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

Re: date divide

Tue, 07 Jan 2014 12:06:24 GMT

thnx mate!

Re: date divide

Tue, 07 Jan 2014 12:06:32 GMT

thnx mate!