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

Replicating Excel formula in Qlik Sense

Capture.PNG

Hi,

Overall RAG 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(G7>0, H7>2),"R", IF(H7>1,"A","G"))

5 Replies
Highlighted

Re: Replicating Excel formula in Qlik Sense

May be this?

If(G7>0 or H7>2, 'R', If(H7>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)
Highlighted
Contributor III

Re: Replicating Excel formula in Qlik Sense

Is it front end or in backend?

Highlighted

Re: Replicating Excel formula in Qlik Sense

Anywhere

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)
Highlighted
Contributor III

Re: Replicating Excel formula in Qlik Sense

Could you please create example in excel and send to me?

Highlighted

Re: Replicating Excel formula in Qlik Sense

Not sure, What are you going to have from my end.

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)