Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Dpage
Contributor III
Contributor III

Highlight Multiple Cells with Listbox Selections

Hello,

I am trying to set this pivot table up so I can indicate which Sales Orders(SO) are complete by checking the boxes in listbox next to the table. I used the expression 

=If(GetFieldSelections([Transactions.Ref Number])=[Transactions.Ref Number],RGB(255,255,0)) for the Background Color of the Transaction.Ref Number Dimension (Labelled SO #)

This works if I make a single selection. However, I would like to make multiple selections so I can check them off as they are completed and I would also like to see all of the Incomplete Sales Orders. In other words, the pivot table would NOT collapse when I make a selection but the cell (which matches the SO Ref #'s selected in the listbox) would be highlighted.

 

Prod. Dash.PNG

1 Solution

Accepted Solutions
Dpage
Contributor III
Contributor III
Author

For anyone who is interested, I was able to solve this issue using an expression I found under another thread titled "Highlight multiple values in pivot without removing the other values in the same pivot". the expression I used was posted by Sasikanth. I used the expression  = If(Wildmatch(Concat(DISTINCT([Transactions.Ref Number]), '|'), [Transactions.Ref Number]) and GetSelectedCount([Transactions.Ref Number])>0,RGB(255,255,0),White()) for the Background color of my item.ref number  dimension.  Then I added the set identifier {1} to my expressions so my selections didn't clear the table of un-selected Transactions.  The result is posted below. I may need to add tweaks to get the full function I am looking for but this is what I was looking to do initially.Now I can indicate what is complete by checking the boxes in the listbox.Now I can indicate what is complete by checking the boxes in the listbox.

View solution in original post

2 Replies
Dpage
Contributor III
Contributor III
Author

Spoiler
Here are Pictures with One selected and with 2 selected

with 1 selectionwith 1 selectionwith 2 selectionswith 2 selections

Dpage
Contributor III
Contributor III
Author

For anyone who is interested, I was able to solve this issue using an expression I found under another thread titled "Highlight multiple values in pivot without removing the other values in the same pivot". the expression I used was posted by Sasikanth. I used the expression  = If(Wildmatch(Concat(DISTINCT([Transactions.Ref Number]), '|'), [Transactions.Ref Number]) and GetSelectedCount([Transactions.Ref Number])>0,RGB(255,255,0),White()) for the Background color of my item.ref number  dimension.  Then I added the set identifier {1} to my expressions so my selections didn't clear the table of un-selected Transactions.  The result is posted below. I may need to add tweaks to get the full function I am looking for but this is what I was looking to do initially.Now I can indicate what is complete by checking the boxes in the listbox.Now I can indicate what is complete by checking the boxes in the listbox.