topic Re: if logic in QlikView

if logic

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

Hi Experts,

Can any one please help me on below if logic.

I have 3 fields named Quality status,Ethics status and compliance status like below.Subsection RAG is the calulated Field.

If one Amber present in the quality,ethics and compliance status fields then Subsection Rag is Amber,

If one Red present in the quality,ethics and compliance status fields then Subsection Rag is Red.

I need to create the subsection RAG field with this logic on backend only.

Thanks in advance.

sunny_talwar — Tue, 21 Nov 2017 14:22:53 GMT

May be this

Ralf_Heukäufer — Tue, 21 Nov 2017 14:30:31 GMT

if([Quality Status] = 'Red' or [Ethics] = 'Red' or [Compliance Status] = 'Red','Red',

if([Quality Status] = 'Amber' or [Ethics] = 'Amber' or [Compliance Status] = 'Amber','Amber')) as [sub-section RAG]

amarnath_krishn — Tue, 21 Nov 2017 14:57:46 GMT

Decode the values to Numbers:

Amber = 2

Red = 0

Green = 1

For Subsection RAG,

Multiply the three and if the result is

1 - Green

0 - Red

Else Amber

Hope it works!