Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends,
How to group by month wise data in qlikview script... I have grouped the data by month wise but I didn't get it exactly. In my data I have multiple records for a single date, but I want all these dates to be included instead of making it as a single data. so, please anyone give an idea to do this.
Could share the sample data ?
Try like this e.g. below
Source:
LOAD
Date,
value,
ID,
Monthname(Date) as Month_Year
from
source;
LOAD
sum(value) as Sum_Value,
Month_Year
resident
Source
group by
Month_Year;
It's not working bro....
Plz say if any other way is there...
it should work ...try like this
Monthname(floor(sheet_date)) as Month_Year
LOAD
sum(value) as Sum_Value,
Month_Year
resident
Source
group by
Month_Year;
If its not working could share the error details or the sample output your looking for ??
I got it bro.. But it is adding only the values which are unique of a single date... I want this to add all the same and unique values for a single date
share the sample excel file ...