Discussion board where members can get started with QlikView.
I'm having trouble using sum and group by in QLikview.
I have a table which looks like this:
The aim is to have a result table like below:
The code I am using is:
sum (Issue Type1) as [sum Issue Type1]
Where [Issue Type1] =1
Group by User;
However an example of the result I am getting is:
Can anyone help me out please? as I ran out of ideas. I have tried using count and or distinct however these did not work
Go to Solution.
Shouldn't you add User as dimensional field in your Group by LOAD?
View solution in original post
Seems to be working
LOAD * INLINE [
User, Issue Type1, Date
1, 1, 01/01/2017
1, 0, 01/01/2017
1, 1, 02/01/2017
2, 1, 02/01/2017
2, 1, 03/01/2017
3, 0, 03/01/2017
4, 1, 04/01/2017
4, 0, 04/01/2017
4, 1, 05/01/2017
Sum([Issue Type1]) as [Sum Of Issue Type 1]
Group By User;
Thank you sunny,
You are completely right it does work I'm so embarrassed my issue was that I wasn't linking "User" between tables and this is why I had such an odd result. My appologies for taking up your time on this, thank you for all your help.
Thank you Stefan,
Life saver too, not linking User was the problem - I feel so stupid. Thank you very much for taking you time to help me out you were a big help