topic Re: Calculations in different dimensions of the visible in QlikView

Calculations in different dimensions of the visible

Wed, 25 Nov 2020 16:16:04 GMT

I have a problem.

I am creating a table chart with 3 dimensions , but the expression must be related to only two ( Aggr ) .

In this case the number 14 should repeat for each BANDEIRA/UF iguals because the AGGR is with BANDEIRA and UF .

Expression about TESTE 00: =COUNT({<EAN=,UN_01={'>0'}>} OUTLET_COD)

Expression about % Bandeira / UF: =AGGR(COUNT({<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ),OUT_BAND,UF)

My goal is to one another to find out how much each EAN is about the total Flag x UF. But when I do that the graph only shows the first EAN .

TKS

sunny_talwar — Fri, 26 Aug 2016 18:50:48 GMT

Try this:

Count(TOTAL <OUT_BAND, UF> {<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ)

or not recommended:

=Aggr(NODISTINCT Count({<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ),OUT_BAND,UF)

Fri, 26 Aug 2016 20:41:01 GMT

Perfect

I'm used

Count(TOTAL <OUT_BAND, UF> {<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ)