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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
OnurT
Contributor II
Contributor II

If statement with multiple conditions

Hello,

How can I write the following excel formula with qlik? Thank you

=IF(AND(G3=0;H3=0;I3=0);0;G3/(G3+H3+I3))

Labels (1)
1 Solution

Accepted Solutions
OnurT
Contributor II
Contributor II
Author

2 Replies
justISO
Specialist
Specialist

Hi, something like this:

IF( G3=0 and H3=0 and I3=0 , 0, G3/(G3+H3+I3) )

You can take a look at Qlik help for more understanding:

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalF...

OnurT
Contributor II
Contributor II
Author

thank you