topic Re: Group by function in QlikView

Group by function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Group by function

avinashelite — Mon, 06 Mar 2017 14:16:40 GMT

Could share the sample data ?

Re: Group by function

Anonymous — Mon, 06 Mar 2017 14:20:56 GMT

Re: Group by function

avinashelite — Mon, 06 Mar 2017 14:21:55 GMT

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;

Re: Group by function

Anonymous — Mon, 06 Mar 2017 14:27:07 GMT

It's not working bro....

Re: Group by function

Anonymous — Mon, 06 Mar 2017 14:27:56 GMT

Plz say if any other way is there...

Re: Group by function

avinashelite — Mon, 06 Mar 2017 14:35:51 GMT

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

Re: Group by function

Anonymous — Mon, 06 Mar 2017 14:50:56 GMT

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

Re: Group by function

avinashelite — Mon, 06 Mar 2017 14:54:33 GMT

share the sample excel file ...

Re: Group by function

Anonymous — Mon, 06 Mar 2017 14:57:23 GMT

Re: Group by function

Anonymous — Mon, 06 Mar 2017 14:59:07 GMT

Plz find the attachment from my original post bro...

Re: Group by function

avinashelite — Tue, 07 Mar 2017 05:43:20 GMT

check this doc, follow the similar approach