Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Group By

Hi guys,

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

Screenshot_5.png

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

Screenshot_6.png

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.

Screenshot_8.png

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.

1 Reply
effinty2112
Master
Master

Hi Siva,

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

Cheers

Andrew