topic Re: Row mark green/Red in QlikView

Row mark green/Red

Sat, 24 Oct 2015 07:32:19 GMT

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

Re: Row mark green/Red

Sat, 24 Oct 2015 16:00:31 GMT

It would be great if i get help on this

Re: Row mark green/Red

simospa — Sat, 24 Oct 2015 16:53:23 GMT

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.

Re: Row mark green/Red

jolivares — Sat, 24 Oct 2015 16:57:34 GMT

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

Re: Row mark green/Red

Sat, 24 Oct 2015 17:33:32 GMT

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

Re: Row mark green/Red

Sat, 24 Oct 2015 18:12:12 GMT

Thanks.

I incorporated your suggestion.

It looks good.

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

Re: Row mark green/Red

Sat, 24 Oct 2015 18:20:19 GMT

Re: Row mark green/Red

Sat, 24 Oct 2015 18:27:35 GMT

Please ignore.

I have removed total