Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Risks (Column AA) is calculated column in Excel, below formula is used in excel to calculate this.Could you please help how we can replicate this in Qlik Sense:
=IF(OR(COUNTIF(AB8:AH8,"R")>0,COUNTIF(AB8:AH8,"A")>3),"R",IF(COUNTIF(AB8:AH8,"A")>1,"A","G"))
Perhaps this?
If(Count(TOTAL <FieldName> FieldName1)>0 or Count(TOTAL <FieldName> FieldName1)>3, 'R',
If(Count(TOTAL <FieldName> FieldName1)>1, 'A', 'G'))