topic Re: Color the first row when the document is opened in QlikView

Color the first row when the document is opened

Anonymous — Mon, 29 Feb 2016 20:09:03 GMT

I have a table in which I need to color the value based on sort order , so what ever value is sorted first - Row should be colored , but this action should take place only when user opens the document ,I mean when user selects some other value which is the secong row as per the sort order , it should color second row. How do I achieve this.

Thanks

Re: Color the first row when the document is opened

Mon, 29 Feb 2016 22:41:18 GMT

Can you mock-up what you want with Excel and send some screenshots please?

Re: Color the first row when the document is opened

Mon, 29 Feb 2016 22:56:22 GMT

Afraid I can't help you there - I don't download and open others' applications.

Screenshots and a better description - and I may be able to assist.

Just guessing though...

I'm assuming you've got a list of APIs and some details about the APIs in a list below that?

Re: Color the first row when the document is opened

Anonymous — Mon, 29 Feb 2016 23:02:30 GMT

Here is the screen shot of the Table : I want the first row in the Table to be highlighted when the App is opened.

So the highlighting is basically selecting the API "display work progress" , but I cannot hard code this value in the Open document triggers, because there might be some other value after few days , so the highlighting should be on sort order , first value in the table.

And here is the screenshot of charts below that,

Re: Color the first row when the document is opened

Tue, 01 Mar 2016 08:59:50 GMT

That's easier, thank you.

By colouring in, I think that you mean selected?

I'd suggest a trigger on activation of the the sheet. Right-click on the sheet that you're working on and select Properties. Then select the Triggers tab, then the Add button.

From the Action Type list use 'Selection' and from the Action list use 'Select in Field'. (These are the defaults.) Press OK.

You'll now have a couple of things to fill in; Field and Search String.

Assuming that the column is called 'ServiceAPI', set the fields to the following values:

Set Field to...
- ServiceAPI
Set Search String to...
- =min ( {1} ServiceAPI )

When the user first opens the document this will select the lowest value for the API - same as if they'd clicked on that first API in the list by hand. And as it's now selected, I'd hope that your chart below would also update appropriately.

*** EDIT ***

You don't necessarily want the min ( API ) I've realised. You want the first one in the table selected. Back later - work to do!

Re: Color the first row when the document is opened

mato32188 — Tue, 01 Mar 2016 09:40:38 GMT

Hi,

set 2 variables in variable expression tab; vColor =Pick($(vSwitch), YourColor, White())

vSwitch without value

in your chart dimension for each field to be highlighted edit background color: =if(RowNo()=1,$(vColor))

in document properties, triggers tab: Document Event Trigger, OnOpen create External-SetVariable vSwitch with value 1

optional:

in your sheet: create action button to restore white color External-SetVariable vSwitch with

value 2

Re: Color the first row when the document is opened

Anonymous — Tue, 01 Mar 2016 18:12:06 GMT

Please find the attached App , I get an error :

And also will this change the color of entire row ? or just the dimension , I am trying to get the color for entire row which is sorted - first row when the document is opened. But later is a value is selected from the table that row has to be colored, so basically which ever row I click that row has to be colored. !

Re: Color the first row when the document is opened

mato32188 — Wed, 02 Mar 2016 15:14:04 GMT

Hi,

I am not able to open your doc since I have only PE.

Coloring need to be set for each column (background color). It would color only first row RowNo(Total)=1 by your second parameter in IF statement...

Re: Color the first row when the document is opened

Anonymous — Wed, 02 Mar 2016 18:51:02 GMT

I am unable to implement this 😞