topic Re: List Box / Multibox Expression in QlikView

List Box / Multibox Expression

bxprokop — Sat, 16 Nov 2024 02:46:20 GMT

Currently, I have an Expression in the attached Qlik file called Percentile Of Target Company. I would like to create a list box or multibox that uses this Expression to all me to filter by the Percentile. I have tried using the Expression created but it does not work when creating a list box or multibox. Can someone provide guidence on how to adjust this Expression to work in a list box / multi box. Thanks in advance for your help.

Re: List Box / Multibox Expression

Frank_Hartmann — Sun, 11 Aug 2019 13:01:05 GMT

see attached

listbox expression:

=aggr(IF(IsNull(sum({Target} TotalCharges)/sum({Target} volume)),'No Charge', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.1),'10th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.25),'25th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.4),'40th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.5),'50th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.6),'60th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.75),'75th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.80),'80th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.85),'85th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.9),'90th Percentile', IF(sum({Target} TotalCharges)/sum({Target} volume)<fractile(AverageCharge,0.95),'95th Percentile', '>95th Percentile'))))))))))),category)

hope this helps

Re: List Box / Multibox Expression

Brett_Bleess — Wed, 28 Aug 2019 14:47:22 GMT

Brian, did Frank's post and updated example get you what you wanted? If so, please consider using the Accept as Solution button on his post to give him credit for the help with things. If you did something different, consider posting that and you can then mark that as well, so others will know what worked here.

Regards,
Brett