topic Re: Button Trigger to Exclude multiple values in QlikView

Button Trigger to Exclude multiple values in qliksense

dunnalahk123 — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

i want to exclude multiple values from a field by using button

so i created one variable like below

VPointNext

("No-Presence-MAP"|"No-Presence-MAP-Tax-Prohibited"|"No-Presence-SOC"|"No-Presence-PLC"|"No-Presence-PLC-Tax-Prohibited")

and passed variable in button by using select in field and select excluded

='('&'$(VPointNext)'&')'

but what happening here is when i click on button

in current selection box it's excluding but some times from above values if it is null or no data at all , those it is coming in current selection box like below

how to get rid of that. whether it has data or not it should not show the names given in the list

Re: Button Trigger to Exclude multiple values

edwin — Wed, 28 Apr 2021 20:23:11 GMT

if you want those values excluded from your expression (in a chart for example) instead of excluding it in the selection just exclude it in your set analysis

{<[FIELD]-={'No-Presence-MAP','No-Presence-MAP-Tax-Prohibited','No-Presence-SOC','No-Presence-PLC','No-Presence-PLC-Tax-Prohibited'}>}

and use a variable to conditionally turn the expression on or off

Re: Button Trigger to Exclude multiple values

dunnalahk123 — Thu, 29 Apr 2021 06:32:28 GMT

Hi Edwin,

Thank you for your Response.

no , users want to see when they click on button in current selection they want to see .

For your Reference attached QVW file . in that when you click on service delivery on time for POINTNEXTSUPPORT_CATEGORY i should see only HPE Presence as remaining should be excluded .