topic Re: IF Statement within a Text Box in QlikView

IF Statement within a Text Box

Thu, 21 Aug 2014 09:02:29 GMT

Hi,

I've used the below formula in a textbox

=If(ActivityType='RiskProgressRAG' and Qty = 'Green','Green',If(ActivityType='RiskProgressRAG' and Qty = 'Red', 'Red','Blank'))

I'm hoping that this will give me the Text Green, Red or Blank. However it only works when i select the ActivityType, otherwise it always returns blank. Is there a formula that will give me the result without having to make the selection within the ActivityType Field.

Many Thanks

Re: IF Statement within a Text Box

hannan_t — Thu, 21 Aug 2014 09:05:04 GMT

Where you need the colour green you have ti mention the RGB Value of green

=If(ActivityType='RiskProgressRAG' and Qty = 'Green', RGB(0,127,0), If(ActivityType='RiskProgressRAG' and Qty = 'Red', RGB(255,0,0), RGB(255,255,255))

Re: IF Statement within a Text Box

tresB — Thu, 21 Aug 2014 09:08:52 GMT

Try like:

=If(Max( If(ActivityType='RiskProgressRAG' and Qty = 'Green',1,0))=1, 'Geen'),

If(Max( If(ActivityType='RiskProgressRAG' and Qty = 'Red',1,0))=1, 'Red'), 'Blank'))

Re: IF Statement within a Text Box

Thu, 21 Aug 2014 09:44:57 GMT

Thankyou Very Much