Discussion board where members can learn more about Qlik Sense App Development and Usage.
Can you help me please?
In Table 1, I calculated the maximum use of POS by store, date and period time.
In table 2, shows only the fact table.
I need to know which an expression that returns only the maximum use of the POS as shown in the table 3
Try as below, or provide a sample app or sample data
=Max(TOTAL <Store> ExpressionforProductivity )
the app is attached now.
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
Table 2: fact table
Ticket = Sum(Tempo_Cupom)
Availability = Sum(Tempo_Uso)
Productivity = Ticket / Availability
Table 3, is just image. In this table that I need the expression
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)
Thank you so much!
Attaching something simpler
=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
Also please close the thread by marking a response as correct
Qlik Community Tip: Marking Replies as Correct or Helpful
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!
If you are still looking for an answer, use the below