Skip to main content

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Button Trigger to Exclude multiple values in qliksense

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

 

 

2 Replies
edwin
Master
Master

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

dunnalahk123
Creator III
Creator III
Author

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 .