-
Re: Calculate peak usage of the POS
Vineeth Pujari Feb 12, 2017 10:29 AM (in response to Claudio Reis )Try as below, or provide a sample app or sample data
=Max(TOTAL <Store> ExpressionforProductivity )
-
Re: Calculate peak usage of the POS
Claudio Reis Feb 12, 2017 10:35 AM (in response to Vineeth Pujari)Hi, Vineeth,
the app is attached now.
-
Re: Calculate peak usage of the POS
Vineeth Pujari Feb 12, 2017 10:43 AM (in response to Claudio Reis )Hi,
I'm not able to access my machine that has a licensed QV, can you telll me the fields used / Expressions you have in the table so I can recreate
-
Re: Calculate peak usage of the POS
Claudio Reis Feb 12, 2017 11:09 AM (in response to Vineeth Pujari)Hi,
Table 1:
Dimensions
Nro_Loja
Qtd_Uso_PDV_FH
Faixa_Horario
Expression
Count(Aggr(if(Rank(Max(Qtd_Uso_PDV_FH),1)=1,1),Nro_Loja,Faixa_Horario))
Table 2: fact table
Dimensions
Nro_Loja
Qtd_Uso_PDV_FH
Expression
Ticket = Sum(Tempo_Cupom)
Availability = Sum(Tempo_Uso)
Productivity = Ticket / Availability
Table 3, is just image. In this table that I need the expression
-
Re: Calculate peak usage of the POS
Vineeth Pujari Feb 12, 2017 3:35 PM (in response to Claudio Reis )Try
Dimension:
Nro_Loja
Expressions:
1) Max(AGGR(MAX(Qtd_Uso_PDV_FH),Nro_Loja))
2) AGGR(if(Qtd_Uso_PDV_FH = MAX(AGGR(NODISTINCT MAX(Qtd_Uso_PDV_FH),Nro_Loja)), sum(Tempo_Cupom)),Nro_Loja,Qtd_Uso_PDV_FH)
3) AGGR(if(Qtd_Uso_PDV_FH = MAX(AGGR(NODISTINCT MAX(Qtd_Uso_PDV_FH),Nro_Loja)), sum(Tempo_Uso)),Nro_Loja,Qtd_Uso_PDV_FH)
4) Colum(2)/Colum(3)
-
Re: Calculate peak usage of the POS
Claudio Reis Feb 12, 2017 5:14 PM (in response to Vineeth Pujari)Hi,
It worked!!!
Thank you so much!
-
Re: Calculate peak usage of the POS
Vineeth Pujari Feb 13, 2017 5:03 AM (in response to Claudio Reis )Hi claudio
Attaching something simpler
Dimensions:
Nro_Loja
calculatedDimension:
=aggr(if(Qtd_Uso_PDV_FH = Max(TOTAL <Nro_Loja> AGGR(MAX(Qtd_Uso_PDV_FH),Nro_Loja,Qtd_Uso_PDV_FH)) , Qtd_Uso_PDV_FH),Nro_Loja,Qtd_Uso_PDV_FH)
<<Check Suppress when value is null() for this dimension
Expressions:
sum(Tempo_Cupom)
sum(Tempo_Uso)
Column(1)/Column(2)
Also please close the thread by marking a response as correct
Qlik Community Tip: Marking Replies as Correct or Helpful
-
Max Use POS .qvw 6.4 MB
-
Re: Calculate peak usage of the POS
Claudio Reis Feb 23, 2017 12:23 PM (in response to Vineeth Pujari)Hi,
I have another situation, can you help me, please?
1. Create a bar chart that represents only the time bands where the amount of POS usage is greater than or equal to the value of the variable by calculating the average availability time.
2. Insert a line in the bar chart showing witch is the frequency in periods ranges the amount of POS in use are greater than or equal to the value of the variable.
Thanks in advance!
-
Max Use POS_2 .qvw 249.0 K
-
Re: Calculate peak usage of the POS
Vineeth Pujari Mar 10, 2017 3:46 AM (in response to Claudio Reis )If you are still looking for an answer, use the below
=if(Count(Qtd_Uso_PDV_FH)>=$(vQty_POS),Count(Qtd_Uso_PDV_FH))
-
-
-
-
-
-
-
-