Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

sumif

Hi

I have these there table:

  

item numberper unit
10090
20040
30030
50020
40050

   

item numberDateqty
1005/20/20161000
2006/20/20162000
3007/20/20163000
4008/20/20164000
1005/20/20172000
2006/20/20173000
3007/20/20174000
4008/20/20175000

  

Dateyearmonth
5/20/201620165
6/20/201620166
7/20/201620167
8/20/201620168
5/20/201720175
6/20/201720176
7/20/201720177
8/20/20172017

8

How would I calculate the total Qty by per unit based on year?

the result should be like these:

  

Row Labels qty/per unit
2016 241
2017 331
Grand Total                  572

and the detail table is:

     

item numberDateqtyunitQty/per unityearmonth
1005/20/201610009011.1111111120165
2006/20/20162000405020166
3007/20/201630003010020167
4008/20/20164000508020168
1005/20/201720009022.2222222220175
2006/20/20173000407520176
3007/20/2017400030133.333333320177
4008/20/201750005010020178
Tags (1)
1 Solution

Accepted Solutions

Re: sumif

Try this expression

Sum(qty/[per unit])

Capture.PNG

View solution in original post

2 Replies

Re: sumif

Try this expression

Sum(qty/[per unit])

Capture.PNG

View solution in original post

Highlighted
Creator
Creator

Re: sumif

Thank you