Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be like attached sample?
May be like attached sample?
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
thnx mate!
thnx mate!