Row mark green/Red

[#1]

Hi,

I need help from you. I want to add radio button red / green beside of each row on the basis of each calculation.

If the END OF SUPPORT fullfill the below condition then i want to mark it green radio button or green colour(row) otherwise red. I am not able to fit the below condition into straight table because we don't have any measure/expression.

Not applicable

Not Yet published

date > 18 month

[#2]

It would be great if i get help on this

[simospa]

Hi Sesa,

take a look at the .qvw attach. I use green/red led for the first two conditions (single and combo).

For the 3rd condition (date > 18 month) you'd like to implement a field in your load script to transocode your expression, that is "irregular" in an expression that you can easily use to applya condition.

Let me know.

S.

[jolivares · Accepted solution]

First try to convert your End of Support into a Date.  For instance, End 2016 =  31.12.2016; not applicable NA.

Then  this date is your input for the column that you need.

Check an example attached

[#5]

Great apprciate your response ...If the date not yet published  then?

[#6]

Thanks.

I incorporated your suggestion.

It looks good.

One extra line is showing in between heading and actual content any idea?

[#7]

[#8]

Please ignore.

I have removed total