# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Not applicable

## Calculations in different dimensions of the visible

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Calculations in different dimensions of the visible

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)

2 Replies
Highlighted
MVP

## Re: Calculations in different dimensions of the visible

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)

Highlighted
Not applicable

## Re: Calculations in different dimensions of the visible

Perfect

I'm used

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