Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shahafei2
Creator
Creator

Set analysis sum with aggr or aggr sum with condition

Hi all,

I would like to calculate order's volume per warehouse in straight table 

The dimensions are Date, Time and Order D

In the DB each order contains multiple lines (Products) with different volume and quantity  

the calculation that i'm trying to use for WH A :

Sum({<WH={'A'}>}(Quantity*Volume))

but for some reason im getting wrong result

 

I suspect that the reason is the different volume/quantity in each line

there is a way to calculate it with inner aggr ? 

3 Replies
jonathandienst

>>but for some reason im getting wrong result

That's not a lot of information to diagnose your problem. There is nothing obviously wrong with your expression, but whether it is right or wrong it depends on your data model.

>>there is a way to calculate it with inner aggr ? 

Perhaps, but don't use an aggr if its not required.

Are there a lot of null values in either field? This could be a problem. If either field has a null value, the result is 0 even if the other field is not null.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
marcus_sommer
MVP & Luminary
MVP & Luminary

Your expression might need an aggr like:

sum(aggr(Sum({<WH={'A'}>}(Quantity*Volume)), OrderID, ProductID))

but I think it would be better to calculate Quantity*Volume already within the script.

- Marcus

shahafei2
Creator
Creator
Author

Thank you, i will try to calculate it in the script instead