topic Re: Variable Extension and Pick Function in App Development

Variable Extension and Pick Function

Nolan — Sat, 16 Nov 2024 17:29:00 GMT

Good Afternoon,

https://extendingqlik.upper88.com/tag/variable/#:~:text=One%20of%20the%20main%20uses,or%20measures%20in%20a%20chart.&text=In%20that%20case%20you%20can,integer%20between%201%20and%20N.

We are using the variable extension and pick function shown above to have 6 different options for a KPI on our sheet. There are 6 different toggle buttons to flip between them. Everything is working perfectly, except one of our options is in Sales ($) and the rest of the 5 are all in units. Is it possible to change the formatting so only the first option shows as $?

The KPI expression is:

pick(vDashboard,
Sum([ TD Quota]),
Sum([ FFX Quota]),
Sum([IV Quota]),
Sum([Product Quota]),
Sum([Base Quota]),
Sum([HSM Quota]))

There is obviously the number formatting drop down, but as far as I can tell whichever option you pick then applies to all 6 of the variations.

Any advice is much appreciated.

Nolan

Re: Variable Extension and Pick Function

skamath1 — Tue, 16 Feb 2021 17:06:48 GMT

you can use the num function with the sum.

num(sum(Sales),'$#,###.00') )

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Num.htm

Re: Variable Extension and Pick Function

Nolan — Tue, 16 Feb 2021 17:23:48 GMT

Thank you for the response!

I have changed the Formatting drop down to 'Number' and added this to the expression:

pick(vDashboard,
num(Sum([TD Quota]),'$#,###.00'),
Sum([FFX Quota]),
Sum([IV Quota]),
Sum([Product Quota]),
Sum([Base Quota]),
Sum([HSM Quota]))

Unfortunately the first toggle still appears as Units. Is this the correct notation? Any other suggestions?

Re: Variable Extension and Pick Function

skamath1 — Tue, 16 Feb 2021 17:33:44 GMT

add the num to other expressions of sum

like num(sum( [yourfieldname],'#,##0')

also check the property of the number expression as below.

Re: Variable Extension and Pick Function

Nolan — Mon, 22 Feb 2021 17:26:18 GMT

I have tried this and am still getting an error: 'error in expression: ")" expected'

I believe my syntax is correct, so not sure what the problem is. Any advice?

pick(vDashboard,
num(Sum([TD Quota]),'$#,###.00'),
num(Sum([FFX Quota]),'#,###.00'),
num(Sum([IV Quota]),'#,###.00'),
num(Sum([Product Quota]),'#,###.00'),
num(Sum([Base Quota]),'#,###.00'),
num(Sum([HSM Quota])'#,###.00')
)

Re: Variable Extension and Pick Function

skamath1 — Mon, 22 Feb 2021 17:34:31 GMT

You were missing one comma in the expression num(Sum([HSM Quota])'#,###.00')

Below is the correct expression..

Re: Variable Extension and Pick Function

Nolan — Mon, 22 Feb 2021 17:48:04 GMT

sorry for the silly mistake!

Thank you I have now put in the correct expression and I have changed the Number Formatting to measure expression. However when I use the Toggles the number formats are all still the same:

(1st KPI which should be $)

(2nd KPI which should be #)

Re: Variable Extension and Pick Function

skamath1 — Mon, 22 Feb 2021 18:07:44 GMT

Is it possible to attach a sample qvf file to really look at the chart object and expressions? otherwise it is difficult to understand the issue.