Group by function

[Anonymous]

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.

[avinashelite]

Could share the sample data ?

[Anonymous]

[avinashelite]

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;

[Anonymous]

It's not working bro....

[Anonymous]

Plz say if any other way is there...

[avinashelite]

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 ??

[Anonymous]

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

[avinashelite]

share the sample excel file ...

[Anonymous]