topic Re: Populating RAG status based on Date in QlikView

Populating RAG status based on Date

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a requirement where I need to plot the RAG status (Red, Amber, Green). Below is how my data look.

Based on this, I need to populate like below.

Arthur_Fong — Thu, 22 Aug 2019 04:11:45 GMT

There you go:

Qvw attached for reference.

Refer to Chart Properties>Expressions>Expand the '+' and look at Background and Text Color.

Thanks and regards,

Arthur Fong

Arthur_Fong — Thu, 22 Aug 2019 07:15:41 GMT

Attached is a better way to show your result without Team show as null value:

Do take a look on the logic at script level.

Thanks and regards,

Arthur Fong

sayadutt — Thu, 22 Aug 2019 14:00:26 GMT

Hello,

The Edit Script has more tabs.

Do we need these many tabs?

Arthur_Fong — Thu, 22 Aug 2019 14:10:31 GMT

You may discard the tabs right after the exit script.