Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table and a sankey chart.
The sankey chart shows the revenue flow from the node products into the node imports and exports.
The table has a column with all the products.
The current behavior of the sankey chart when I select a product from the table is: the sankey chart removes all other product nodes to focus only on the selected product.
The behavior I want is for the link between the product and the corresponding imports and exports to be highlighted, while the rest of the nodes remain visible but "dull" (the same behavior as when hovering over the product node, basically)
Basically I want this:
Instead of this:
Is there a way to achieve this behavior?
Hi @PaoHL
You can go and check out "Qlik Brushing"
https://emarkanalytics.com/blog/data-brushing-on-a-user-defined-set/
https://ometis.co.uk/blog-news/data-brushing-qlik-sense
I cant get the "other" (Non selected values) to just be a lighter color, But here is the result
Top is normal > Bottom is with Brushing
My expression I just changed to exclude the selection in Crop.
Sum( {< Crop =>} Actual ) (as this is the value I am selecting) and then for the color (in the presentation tab)
IF(Match(Grade, 1,2,3),
Pick(Match(Grade, 1,2,3), rgb(90, 189, 87), rgb(153, 189, 87), rgb(189, 162, 87)), // This is for the selected ones
Rgb(206, 206, 206)) // This is for the non-selected values
Let me know if this "kinda" solves your problem.
Regards Jandre
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn