Set Analysis

[krishna20]

Hi Folks,

I wrote an expression using if condition .It's taking too much loading time.

I wrote conditions in variables and calling them in the expressions too.But, still facing performance issue.

Sheet can't able to open in access point. Please help me to convert this expression in pure set analysis.

Please find my expressions.

Original one :

Sum(if(CE_EST_TYPE='1' and CE_CLOSE_YN='0' or  CE_CLOSE_YN='1' and CE_CLOSE_DT>CLM_LOSS_DT,CE_AMT_LC_1))

Variable :

vValue1 : CE_EST_TYPE='1' and CE_CLOSE_YN='0' or  CE_CLOSE_YN='1' and CE_CLOSE_DT>CLM_LOSS_DT

Expression :

Sum(if(vValue1,CE_AMT_LC_1))

Regards

Krishna

[krishna20]

Hi Steve,

This apply mapping logic is working for some values and not others. But the CLM_LOSS_DT is same. The logic is going wrong somewhere. Please find the snapshot of database values. The first two values are only including in summing but the below values are not.Please suggest me.

[stevedark]

You will just need to break things down into manageable chunks and unit test each part.

If you need extra assistance you should maybe consider getting in a Qlik consultant who can work things through with you on site.

It is very difficult for me to see a solution from your descriptions and screenshots.

[krishna20]

Hi Steve,

I'm really very thank full to you.It was amazing support from you.The problem almost solved. I learned this mapping concept from you clearly.Thank you for your post on Apply map.

Regards

Krishna

[stevedark]

Hope you can figure out what you need to get your solution over the finish line.  Double check the keys you are mapping on - they need to be 100% identical - case and all.

Good luck.