topic How to replicate excel formula based on multiple columns in Qlik in QlikView

How to replicate excel formula based on multiple columns in Qlik

pawwy1415 — Thu, 30 Nov 2017 15:12:54 GMT

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"))

Re: How to replicate excel formula based on multiple columns in Qlik

Anil_Babu_Samineni — Thu, 30 Nov 2017 15:20:57 GMT

Perhaps this?

If(Count(TOTAL <FieldName> FieldName1)>0 or Count(TOTAL <FieldName> FieldName1)>3, 'R',

If(Count(TOTAL <FieldName> FieldName1)>1, 'A', 'G'))