Group By

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

Hi guys,

I have a small issue in using group by along with sum in load script.

Using the above code, I'm getting the expected result but with a small issue as shown below.

According to my code in the script, I need the maximum date count upto 31 but here I'm getting values more than that. I checked my source and found the problem too.

In the above screenshot, I have three values for that file date "10/04/2017" based on the file type but for date "10/03/2017" it's fine. I need to sum both values for the file type "RNI".

Please help me out to achieve this.

Attached the sample QVW below.

Thanks,

Siva.

Re: Group By

effinty2112 — Mon, 16 Oct 2017 10:14:14 GMT

Hi Siva,

Maybe add DISTINCT to your left join's load statement.

Cheers

Andrew

topic Group By in QlikView

Group By

Re: Group By