Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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):
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!!!
it gets back "0" too...
Are these the fields in your dashboard?
Year
Month
Country
[Day to Day]
[Real]
Also, Year Month and Country are your dimensions in the chart?
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?
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!