Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Intuitive
Contributor II
Contributor II

Removing selection for concatenated field

Lets say, I have  four fields:

branch_id

branch_name

date 

sales

On the chart I used branch_id&' -'&branch_name to display a branch 

On the same sheet I have a KPI that I want to be able to alter by selecting dates but not to be altered if branches are selected on the chart

I used sum({$<branch_id=>}sales), it didn't work. 

sum({$<branch_id=,branch_name=>}sales), didn't work. 

sum({$<branch_id=,branch_name=>}sales), didn't work. 

sum({$<branch_id=,branch_name=,[branch_id&'-'&branch_name]=>}sales), didn't work

GetCurrentSelections() results to "branch_id&' - '&branch_name:100-main branch"

If I change the field on the chart from branch_id&' -'&branch_name to branch_id

then sum({$<branch_id=>}sales) works.

 

 

Labels (2)
1 Reply
bramkn
Partner - Specialist
Partner - Specialist

Using concatenated fields can cause some strange behaviour. The best way is to create a new field with these 2 fields combined in the script instead of the dashboard.