Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
abhinavbose
Creator III
Creator III

Group by function

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.

11 Replies
avinashelite

Could share the sample data ?

abhinavbose
Creator III
Creator III
Author

Screenshot_13.png

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;

abhinavbose
Creator III
Creator III
Author

It's not working bro....

abhinavbose
Creator III
Creator III
Author

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

abhinavbose
Creator III
Creator III
Author

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

abhinavbose
Creator III
Creator III
Author

Screenshot_13.png