Sql to QV expressions

[priyarane]

Hi Exprets,

I got some requiremets from sql related and those I need to write as expression in straight table and those are I have attached.

Please help me.

Thank you

[Anonymous]

Hi Priya,

It will be good if you provide sample data.

And also go through these links. This may help you!

Set Analysis: syntaxes, examples

Learning Set Analysis from Scratch

Thanks and Regards,

Laxmi

[anbu1984]

Change type_new in ('SME_EU','SME_EU_RET') to Match(type_new,'SME_EU','SME_EU_RET')

Change nvl(ead_pro,0) to If(IsNull(ead_pro),0,ead_pro)

Change asses_class_new like '%EQT%' to asses_class_new like '*EQT*'

DECODE(E1, E2, E3, E4) - Equivalent logic IF E1 = E2 THEN E3 ELSE E4

Change decode(ccf,0,1,ccf) to If(ccf=0,1,ccf)

[priyarane]

Hi Anbu,

but I need to write in expression(straight table)

[anbu1984]

In which statement do you face difficulty to convert to expr?

For some of the rows, aggregation function is not provided in attached pic. You need to get the aggregation function for the same.

[priyarane]

Hi Anbu,

how can I write the below one:

"nvl(bis_past_due,'F')!='F' or (asset_class_category_new in('CLAIM_EQUIT','CLAIM_CIU','CLAIM_SECURITIZATION') or asset_class_new like '%EQT%') then sum (rwa)

if bis_entity_type_new in('SME_EU','SME_EU_RET') then sum(rwa)/.7619 else sum(rwa)"

[anbu1984]

Sum(

If( If(IsNull(bis_past_due),'F',bis_past_due)!='F' or

Match(asset_class_category_new,'CLAIM_EQUIT','CLAIM_CIU','CLAIM_SECURITIZATION') or

asset_class_new like '*EQT*'),rwa,

If(Match(bis_entity_type_new,'SME_EU','SME_EU_RET'),(rwa)/.7619,rwa)

)

)

[priyarane]

Hi Anbu,

Its not working out

[anbu1984]

Can you explain what is not working? Do you have error in expression or result is not correct?

Can you post sample data