topic Re: Group by in script in QlikView

Group by in script

venkatbza — Sat, 16 Nov 2024 00:35:06 GMT

Hi Friends,

i need a help in creating a group by expression

below is my table.

Tmp:

load

Salesorder,

Material,

from xyz.qvd;

in that table i need to create a one more column called count of material. so my final out put will be Salesorder,Material,materialcount from the table.

I have created a below script, but it is giving duplicate records. please help me my approach is correct or not.

Tmp:

load

Salesorder,

Material,

count(Material) as materialcount,

from xyz.qvd group by Salesorder,Material;

Thanks,

Venkat

Re: Group by in script

Taoufiq_Zarra — Fri, 29 May 2020 08:03:03 GMT

May be :

Tmp: load Salesorder, Material from xyz.qvd; output: noconcatenate load Salesorder,Material,count(Material) as materialcount resident Tmp group Salesorder,Material; left join load * resident Tmp; drop table Tmp;

Re: Group by in script

agigliotti — Fri, 29 May 2020 08:44:41 GMT

your script looks good to me.
What do you mean with "duplicate records" ??