topic Re: How do i color the selected Row in QlikView

How do i color the selected Row

Anonymous — Mon, 29 Feb 2016 20:36:23 GMT

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

Thanks!

Re: How do i color the selected Row

sunny_talwar — Mon, 29 Feb 2016 20:39:21 GMT

If the table doesn't filter out based on the user selection (because it is restricted by set analysis), you can use non-set analysis version to tell it to color the rows.

Re: How do i color the selected Row

Anonymous — Mon, 29 Feb 2016 20:40:49 GMT

I mean the row which is selected, say for example a user clicks on a cell ( any dimension cells , I have 3 dimensions) in the table I want to highlight the row

Re: How do i color the selected Row

sunny_talwar — Mon, 29 Feb 2016 20:45:20 GMT

Something like this or no?

Re: How do i color the selected Row

Anonymous — Mon, 29 Feb 2016 20:50:26 GMT

Attached my application , I have 2 background expressions for last 2 columns other than those columns all the cells should be colored for the selected Row. in the table , is user clicks on group or api or date that row should be highlighted. !

Re: How do i color the selected Row

Anonymous — Mon, 29 Feb 2016 21:28:16 GMT

Is this doable ?

Re: How do i color the selected Row

sunny_talwar — Mon, 29 Feb 2016 21:50:18 GMT

I am still trying to see if it is doable or not.

Re: How do i color the selected Row

Anonymous — Mon, 29 Feb 2016 22:00:00 GMT

oh ok , thanks for looking into this ..

My whole intension is to show the API value selected in the line charts below the table , when a user selects a API from the table , the title in the below charts shows it , I initially had a background expression for dimensions - Date,Group and API , as like below ,

if(getfieldselection(Function)=Function,yellow()) .. but this expression highlights the row only when API is selected , when Date or Group is selected I get a bunch of rows highlighted with selected date and Group which I don't want. It is ok if all the rows are highlighted for the selected API.

Say for example User selects a Date - 2/29/2016 , instead of coloring all 2/29/2016 , color all the rows for the API value in the selected Row

Re: How do i color the selected Row

Anonymous — Tue, 01 Mar 2016 03:26:54 GMT

Is there a alternative to get this done?

Re: How do i color the selected Row

rwunderlich — Tue, 01 Mar 2016 05:39:54 GMT

1. In the load, generate a unique id in the ServiceTimeSeries table using RecNo().

RecNo() as RecId

2. Add the RecId field as a Dimension in the chart, but hide it on the Presentation pane.

3. When an expression column is clicked, all Dimensional values on that row get selected, including the hidden RecId, So now you only need to test for the RecId in your background color expression.

4. Selecting an Dimension cell will only select that Dimension field. So you will need to modify each dimension as a calculated dimension that uses aggr() to "scope" the RecId column into the selection -- as shown here:

Scoping Selections with Aggr() | Qlikview Cookbook

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How do i color the selected Row

Anonymous — Tue, 01 Mar 2016 06:27:49 GMT

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.

Re: How do i color the selected Row

rwunderlich — Tue, 01 Mar 2016 13:33:22 GMT

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

Re: How do i color the selected Row

Anonymous — Tue, 01 Mar 2016 16:06:43 GMT

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

Re: How do i color the selected Row

rwunderlich — Tue, 01 Mar 2016 16:34:58 GMT

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

Re: How do i color the selected Row

Anonymous — Tue, 01 Mar 2016 16:58:54 GMT

Yes that is right.

Re: How do i color the selected Row

Anonymous — Wed, 02 Mar 2016 18:16:47 GMT

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