Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Partner
Partner

Set Analisys collunm conditional

Podem me ajudar por favor?

É possível efetuar um cálculo com set analisys utilizando o nome de uma coluna calculada?

segue exemplo:

Imagem_Community2.png

7 Replies

Re: Set Analisys collunm conditional

Not within the Aggr() function, you can't. Within Aggr() you need to replace the expression label with the actual expression itself

Partner
Partner

Re: Set Analisys collunm conditional

Hi Sunny!

I override but it worked only when I select a line.

Follows the new expression:

Count(DISTINCT If(Aggr(NODISTINCT Count(Qtd_Uso_PDV_FH),Agrupamento) >= $(=Floor((1-(Simul_Prod - AGGR(if(Qtd_Uso_PDV_FH >= MAX(AGGR(NODISTINCT MAX({$<Faixa_Horario,Semana,Nro_PDV,Dia>}Qtd_Uso_PDV_FH),Nro_Loja)), sum({$<Faixa_Horario,Semana,Nro_PDV,Dia>}Tempo_Cupom)),Nro_Loja,Qtd_Uso_PDV_FH) /

   AGGR(if(Qtd_Uso_PDV_FH >= MAX({$<Faixa_Horario,Semana,Nro_PDV,Dia>}AGGR(NODISTINCT MAX({$<Faixa_Horario,Semana,Nro_PDV,Dia>}Qtd_Uso_PDV_FH),Nro_Loja)), sum({$<Faixa_Horario,Semana,Nro_PDV,Dia>}Tempo_Uso)),Nro_Loja,Qtd_Uso_PDV_FH))) * Max(Aggr(Count({$<Faixa_Horario,Semana,Dia>}DISTINCT Nro_PDV),Nro_Loja,Data)))), Data))

Imagem_Community3.png

Re: Set Analisys collunm conditional

It would be difficult to comment without having a look at the app and playing around with it. Would you be able to share a sample?

Partner
Partner

Re: Set Analisys collunm conditional

Hi, Sunny!

I attached a template.

Thanks!

Partner
Partner

Re: Set Analisys collunm conditional

Hi, Sunny!

I attached a template.

Thanks!

Re: Set Analisys collunm conditional

What are you trying to do with this part?

Aggr(NODISTINCT Count(Qtd_Uso_PDV_FH),Agrupamento)

This is part is giving no result in your table...

Partner
Partner

Re: Set Analisys collunm conditional

Hi, Sunny!

My idea is that this expression could calculate the frequency, but only works if you select a line.

Could you help me build the correct expression?

thaks in advance!

Imagem1.png