-
Re: %Mix
Oleg Troyansky Oct 21, 2016 4:42 PM (in response to Elina Vergara)Hi Elina,
I don't think you really need the AGGR function for this calculation. I'd use the following:
SUM({<condition>} Sales)/sum({<condition>} Total Sales)
cheers,
Oleg Troyansky
Learn AGGR, Set Analysis, and many other advanced techniques from my book QlikView Your Business.
-
Re: %Mix
Elina Vergara Oct 21, 2016 5:30 PM (in response to Oleg Troyansky )I've already tried that option, but I don't have result. It could be because I have canal and region as dimension??
-
Re: %Mix
John Witherspoon Oct 21, 2016 7:20 PM (in response to Elina Vergara)It looks like you want the %Mix within the Region? Just need to add <Region> after the total in Oleg's expression, I think.
sum({<$(vSetYearAct),$(TipRegion)>} #Sales)
/sum({<$(vSetYearAct),$(TipRegion)>} total <Region> #Sales)-
Re: %Mix
Elina Vergara Oct 21, 2016 11:18 PM (in response to John Witherspoon )sorry, i don´t explain correctly, i have two dimensions. canal and regional, and i have two variables vSetYearAct and TipRegion, the last save if region is north or south, i tried your expression, but do not work.
(sum({<$(vSetYearAct),$(TipRegion)>}TOTAL <Regional>} #Sales)
-
Re: %Mix
Oleg Troyansky Oct 22, 2016 11:08 AM (in response to Elina Vergara)Hi Elina,
it would be a lot easier if you could create a small example and share it. We could then review it and help you find the solution.
cheers,
Oleg Troyansky
-
Re: %Mix
Elina Vergara Oct 23, 2016 3:01 AM (in response to Oleg Troyansky )thannks Oleg, attach file with examples, thanks for your help
-
Prueba.qvw 155.0 K
-
Re: %Mix
Oleg Troyansky Oct 24, 2016 10:52 AM (in response to Elina Vergara)!
Hi Elina,
you simply had an extra bracket } after the TOTAL qualifier. Attached is the corrected formula.
cheers,
Oleg Troyansky
Learn advanced QlikView and Qlik Sense techniques in my book QlikView Your Business
-
Prueba.qvw 154.5 K
-
-
-
-
-
-
-