Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

How to replicate excel formula based on multiple columns in Qlik

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"))Capture1.PNG

1 Reply
Highlighted

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

Perhaps this?

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)