How do i color the selected Row - Page 2 - Qlik Community

Anonymous · ‎2016-02-29

Hi

In a table how do I color the entire (except 2 columns) row on which the user clicks .. ?

Thanks!

Anonymous · ‎2016-03-01

Thank you very much for the Response , I have added the Recid field , but could not get scoping aggr function to work , can you please take a look. When I select a dimension row color does not change.

rwunderlich · ‎2016-03-01

Hmmm...I see the problem. All the RecId values for a date get selected when selecting a Dimension. It does work for the expression columns. You could consider try converting all your Dimensions (except RecId) to Expressions.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Anonymous · ‎2016-03-01

By moving all dimensions to expressions , its not behaving the same... the colors problem gets fixed but it only selects the row which I clicked rather than showing all the values

rwunderlich · ‎2016-03-01

Let me ask for a clarification. You want to click on the Date in a cell, for example, 2/28/2016. You want the date to be used as a filter, and therefore show only the the 2/28/2016 rows. But you want only the row clicked to be highlighted?

-Rob

Anonymous · ‎2016-03-01

Yes that is right.

Anonymous · ‎2016-03-02

Is this not possible at all?

Another requirement - I want to select the Min value of Function when the document is opened , Why does not

min ( {1} function ) work ? I can have it to the triggers when the document is opened , and automatically min value is selected from API and so its colored, basically I am trying to color the first sorted value of Function when the document is opened