Discussion board where members can get started with Qlik Sense.
I have a table and I want to implement a condition that when there is just a "-" in the column, the whole line should be colored (background).
I assume this should be made in the Application GUI. So I tried it already like this: "if(len(Value) < 3,lightgreen(), white())", so the affected column is highlited, but not the whole line.
Any hint would be great.
Thank you in advance. !
Should be easy to reproduce, take any table and go in the first column. There you can mark the table and use the first column and add there a command for the backgroundcolour on the right side under data. This option is taken for the single cell.
Open question, can I expand this feature to the whole line?
I tried already to mention the other columns in the condition but without success..
!Due to functional restrictions this is not possible. On the second column I can not add anything because there is no field for background colour.
Or should I add this in the field of the first one? How to separate them (with a "," it does not work)?
Any other hint?
My target is to mark some special fields in a table which contains a "-" --> so that it is easier to recognize that there are missing values.
As you are not able to colour the entire line using the backgound colour due to functional restrictions, I would suggest you to build an extension to fit your requirment.
I am really worried why everybody is asking for the qvd... ==> no. I don't want to publish my content.
So I've solved this now like this:
I added kpi's instead of dimensions and modified the used form to show only the value without any function. So you get on every field the possibility to create a background colour.
There I added the condition "If(len(Remaining_field) < 3, white(), green())" to every KPI and the result is that the whole line will be green. Only thing is that one dimension has to be there, so I added an additional field, not shown in the GUI but under edit.
Working for me. Thank to all for your help.
Thanks for this hint. But I have absolutly no idea what is mentioned with "build an extension" (maybe I am too new).