Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III
‎2017-11-30 10:12 AM

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

429 Views
0 Likes
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2017-11-30 10:20 AM

Perhaps this?

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
364 Views
0 Likes