Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date divide

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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like attached sample?

View solution in original post

4 Replies
tresesco
MVP
MVP

May be like attached sample?

nilesh_gangurde
Partner
Partner

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

Not applicable
Author

thnx mate!

Not applicable
Author

thnx mate!