Calculation with Set Analys

Wed, 10 Jun 2015 09:53:35 GMT

Hello,

Sum({$<[ProdH_L1]={11},[ProdH_L7Txt]={"Colorm IQ Sun"}>} [DebetFakturaKvantitet]) gives the row 'Colorm Sun'

Sum({$<[SurchGrupp]={"unicolor"}>} [DebetFakturaKvantitet]) gives the row 'Färg' .

[Colorm Sun]/[Färg] , this calculation works but I would like to have it as this

{$<[KundGrupp]-={13}>}[Colorm Sun]/[Färg], but this doesn´t work. so I have to use this

Sum({$<[ProdH_L1]={11},[ProdH_L7Txt]={"Colorm IQ Sun"},[KundGrupp]-={13}>} [DebetFakturaKvantitet])/ Sum({$<[SurchGrupp]={"unicolor"},[KundGrupp]-={13}>} [DebetFakturaKvantitet])

Is it possible to use this calculation, {$<[KundGrupp]-={13}>}[Colorm Sun]/[Färg], if yes,

what have I done wrong?

kindly

Håkan

Re: Calculation with Set Analys

stigchel — Wed, 10 Jun 2015 09:57:29 GMT

No it is not possible, you can only use set expressions in an aggregation function.

Re: Calculation with Set Analys

Wed, 10 Jun 2015 09:59:45 GMT

Thanks for the information.

Håkan

topic Calculation with Set Analys in QlikView

Calculation with Set Analys

Re: Calculation with Set Analys

Re: Calculation with Set Analys