Qlik Community

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 
Search instead 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 ) .


dúvida QV.jpg

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

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)

View solution in original post

2 Replies
Highlighted

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)

View solution in original post

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)