topic Dynamic % based on Slider Top 10 Selection in App Development

Dynamic % based on Slider Top 10 Selection

Keitaru — Tue, 03 Sep 2024 10:09:53 GMT

Hi Qlik experts need help here

have a Straight table with top 10 Ranking items
Goal of this is to be able to adjust the slider bar below with the precentage number changing accordingly to the number of items there. Example top 10 (Percent add up to 100%)
as the slider moves down from 10 to 1 percentage should reflect total number of times in the table, like wise with the ranks. To a point Rank 1 (Top 1 percentage should show 100%).

Would anyone be able to help me with this my current formula for percentage is

Count / sum(TOTAL Count)

But the % number doesnt seem to change dynamically.

Re: Dynamic % based on Slider Top 10 Selection

brunobertels — Tue, 03 Sep 2024 10:49:59 GMT

may be try with aggr

aggr(

Count / sum(TOTAL Count)

, counterparty)

Re: Dynamic % based on Slider Top 10 Selection

Keitaru — Wed, 04 Sep 2024 02:22:27 GMT

Did try this but it showing me top 11 calculation instead of the top N calculation according to the straight table.

Counteryparty count formula:
Count(DISTINCT {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF)

Rank Formula:
Rank(Count(DISTINCT {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF),4)

Percentage:
aggr(Count(DISTINCT {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF) / Count(DISTINCT TOTAL {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF), Counterparty)

Slider settings:
Slider variable vMismatch_Top_Count

Re: Dynamic % based on Slider Top 10 Selection

brunobertels — Wed, 04 Sep 2024 11:34:33 GMT

Hi Not sure

but trying this logic with an If statement

IF(

RANKFORMULA<= VMismatch_TOP_COUNT ,

YOUR MESURE

)

So may be

IF(

Rank(Count(DISTINCT {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF),4)

< = $(vMismatch_Top_Count) ,

aggr(Count(DISTINCT {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF) / Count(DISTINCT TOTAL {<Mismatch_Trade_Settlement_Month={'$(vMonth_Key)'}>}Mismatch_Trade_TXN_REF), Counterparty)

)