topic Re: Apply action on Button with Variable Input in Qlik Automate

Apply action on Button with Variable Input

LK13 — Fri, 25 Oct 2024 13:44:07 GMT

Hello,

I have defined a variable : vPercentPerVendor

I have placed a variable input with Input Box (so i can choose % from 0 - 100 (0.0 - 1))

I have placed a button and added action. Action is select value in the field (Field is dimension Vendor) with following expression: count(DISTINCT sale_service_id) / count( Total DISTINCT sale_service_id) > $(vPercentOfTotalPerVendor).

Down below i have table with following fields: Vendor, Count (Distinct sale_service_id) and % of each Vendor in total count.

Idea is to represent vendors with 10 % or any higher % in relation to the total (which is 100 %).

I Attached SC.

Thank you in advance.

Re: Apply action on Button with Variable Input

Kushal_Chawda — Fri, 25 Oct 2024 14:15:18 GMT

@LK13 You can create calculated dimension for vendor as below. Then check suppress null value option for this calculated dimension

=aggr(if( count(DISTINCT sale_service_id) / count( Total DISTINCT sale_service_id) > $(vPercentOfTotalPerVendor),Vendor), Vendor)

Re: Apply action on Button with Variable Input

LK13 — Mon, 28 Oct 2024 08:50:57 GMT

Something is wrong, it just doesn't show the expected results. Maybe my approach via "select value in the field" is completely wrong, I'm not sure.

Anyway , thank you Kushal very much !

Re: Apply action on Button with Variable Input

Kushal_Chawda — Mon, 28 Oct 2024 09:27:33 GMT

@LK13 Solution I provided is not button solution it is calculated dimension solution for vendor dimension?

Re: Apply action on Button with Variable Input

LK13 — Tue, 29 Oct 2024 07:49:35 GMT

@Kushal_Chawda Actually you are absolutely correct. This approach work. I will just get rid of button and will leave only variable input. So yes calculated dimension will suppress null() and will work as expected.

Thank you.

Re: Apply action on Button with Variable Input

Kushal_Chawda — Tue, 29 Oct 2024 10:24:30 GMT

@LK13 Please accept the appropriate reply as solution if it helped.