topic Using Percentages in a Map Layer in App Development

Using Percentages in a Map Layer

ryanfliehman — Sat, 16 Nov 2024 18:05:03 GMT

Do you know if it's possible to show a percentage using bubble layer or any map layers in Qliksense? I'm trying to show a lab test positivity rate by postal code but I can't seem to get the bubbles to deviate from whole numbers.

Re: Using Percentages in a Map Layer

Lisa_P — Mon, 21 Sep 2020 23:27:50 GMT

You will need an expression to calculate the percentage and then apply that as bubble size or color

Re: Using Percentages in a Map Layer

ryanfliehman — Tue, 22 Sep 2020 11:55:46 GMT

I've created the expression but the bubble size is only showing 1 and I can't figure out how to show it as a percentage and apply a percentage as the bubble size. It just want's to show the bubble size as 1. (see attached).

Expression:

=Count(IF(vSlider<=[PATIENT.AGE] and vSlider2>=[PATIENT.AGE] and [LAB TEST.IS ABNORMAL]='1',LabTestKey))/(Count(IF(vSlider<=[PATIENT.AGE] and vSlider2>=[PATIENT.AGE],LabTestKey))

Re: Using Percentages in a Map Layer

Steven_Haught — Tue, 22 Sep 2020 18:45:44 GMT

@ryanfliehman

If you are using a Geo Analytics bubble layer, you place the sizing expression as a third measure after your lat and long ( or a second measure if using a combined field or geomakepoint) in the Location, Size section. You will also likely need to wrap that expression in the label section in a NUM() Function as such: Num(YOUREXPRESSION, '##.##%')

Re: Using Percentages in a Map Layer

ryanfliehman — Wed, 23 Sep 2020 20:12:35 GMT

Perfect, this did the trick. Thank you!