Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlik Sense and am having trouble with this sequence:
The idea is that in the first situation the cell is painted in green and in the second condition in red, what am I doing wrong?
if(if(isNull (fields_resolutiondate),Interval(fields_updated-[Fecha Creacion], 'DD')) <= 10,'green',
if(isNull(fields_resolutiondate),Interval(fields_updated-[Fecha Creacion],'DD')) > 11,'red')
Thank you, for your help!
If() does indeed take 2-3 parameters:
If(Condition, Then, Else)
You can use multiple conditions, e.g.
If(1=1 AND (2=3 OR 2=2),Then,Else)
And you can nest if statements (two or more as required), e.g.
If(Isnull(SomeField), If(SomeOtherField > 10,Green,Red))
If() does indeed take 2-3 parameters:
If(Condition, Then, Else)
You can use multiple conditions, e.g.
If(1=1 AND (2=3 OR 2=2),Then,Else)
And you can nest if statements (two or more as required), e.g.
If(Isnull(SomeField), If(SomeOtherField > 10,Green,Red))
Thank you for your answer