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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write expression to add column into table

Hi,

I have expression as below.

when I am using this it is showing error as Error in expression:If takes 2-3 parameters

If(MixMatch(Zinc,'Present',

        IF (MixMatch( Coal,'Marbel Transfer'),'Ready',

            If(MixMatch(Zinc,'XX','YY','CC','SS','VV'),'Ready',

              If(MixMatch(Coal,'NOTXX','NOTYY','NOTSS','NOTCC','NOTZZ',

                  If (Not Match(Coal,'Marbel Transfer'),'Ready')))))))) as [Ready],

Please can anyone suggest me how to set this?

Thanks.

21 Replies
Not applicable
Author

Perfect That's exactly working. Thanks.

sunny_talwar

Awesome!