Solved: stuck with where script while loading data. - Qlik Community

Anonymous · ‎2014-09-11

Code	class	amount
AC	Loss	12
BC	Gain	25
CC	Tenure	56

how to write script for code,class dimensions for calculating measure Loss Ratio.

Let say to calculate Loss Ratio the condition is it should take while loading in script.

Code='AC','CC' &Class='Loss','Tenure' .how to write code in edit script

Report Inappropriate Content · ‎2014-09-11

Do you mean like below:

LOAD

*

Resident TableName

where Match(Code,'AC','CC') and Match(class,'Loss','Tenure');

View solution in original post

PrashantSangle · ‎2014-09-11

Hi,

Write

If(wildmatch(code,'AC','CC') AND wildmatch(Class,'Loss'),Tenure) as NewTenure

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-09-11

Do you mean like below:

LOAD

*

Resident TableName

where Match(Code,'AC','CC') and Match(class,'Loss','Tenure');

ajaykumar1 · ‎2014-09-11

Hi,

Whats your expected output? is it 68?

Regards,

Ajay

Anonymous · ‎2014-09-11

Thank for your response working on real data if it works I will close discussion