Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Question about SUMIF in QLIKView

Hello guys!!


    I'm new at QLIK View and i'm having difficulty to sum a quantity with conditions. Here's the thing:



I need to Sum all the collumn "Day to Day * Real" and divide that for the sum of the Real collumn. All that aggregate by the "Ano" collumns, the "Mês" column and the B and C collumn there in blank. All of that to appear in another collumn next to it. That would be (done in Excel):


QLIK Question2.png


I tried the 

Sum(Aggr([Day to Day * Real],Ano,Mês,B,C)) 


With no luck... It's just returns 0s...

Can anyone help me? 

Thanks a lot!!!

Labels (5)
14 Replies
Contributor III
Contributor III

it gets back "0" too...


Are these the fields in your dashboard?

[Day to Day]


Also, Year Month and Country are your dimensions in the chart?

Contributor III
Contributor III

Year = Dimension at the script
Month = Dimension at the script

Country = Dimension at the script
[Day to Day] = Expression in the chart
[Real] = Expression in the chart

The dimensions in the chart are: Year, Month, Column B(Information about the country, also from the script) and Country

The expressions are Programed, Real, Day to Day and "Day to Day * Real"


What are the expressions behind [Day to Day] and [Real]? Is it something like Sum([Day to Day]) or something?

Contributor III
Contributor III

Sorry for the late reply my friend. 

Yes, it was a calculated dimension, but i was able to solve my problem using aggregate.

I used Aggr on all the sum( "day to day" x "real")

and then divided that aggr for the aggr  sum("real")

Using year, month and country for the dimensions in the aggr.

Thanks for all the replies and will have another problem in my next post that is a challenge one!