Hi Friends

[krishna20]

Hi Friends !

I'm having a doubt in applying Nested If expression.My expression is not showing the exact data which is in raw data.Pls check out my expression and help me out ASAP.

=Min({<TP_TXN_TYPE={'POL'}>}if(PROD_CODE='0110',if(TP_SCH_CODE<>'0113',(TR_PREM_LC_1/TR_SI_LC_1)*100)))

[tresesco]

It looks good. However, you can change the expression to:

=Min({<TP_TXN_TYPE={'POL'} ,PROD_CODE={'0110'} , TP_SCH_CODE -={'0113'} >}(TR_PREM_LC_1/TR_SI_LC_1)*100)

and see if the output fits your need.

[krishna20]

=Min({<TP_TXN_TYPE={'POL'} ,PROD_CODE={'0110'} , TP_SCH_CODE -={'0113'} >}(TR_PREM_LC_1/TR_SI_LC_1)*100)

Thank You for your Reply Tresesco .

Its Showing error at '-=' not taking expression.Pls modify it and let me know.

[#4]

Hi Kalyana, You can ignore the error. tresesco's expression is perfect.

[krishna20]

Hi Ram,

Im not getting any output.Its showing Null values.I'm applying this expression for Pivort table.

[tresesco]

So the issue has to be with something in your app. Try to share your sample app so that we can figure it out and help you.

[sasikanth]

hi

try some thing like this

=min({<TP_TXN_TYPE={'POL'} , PROD_CODE={'0110'},TP_SCH_CODE={'*'}-{'0113'}>}(TR_PREM_LC_1/TR_SI_LC_1)*100)

[krishna20]

I'm unable to upload the app Mr.Tresesco.

[tresesco]

Is it because of data security or file size? If so, see this: Preparing examples for Upload - Reduction and D... | Qlik Community

[krishna20]

Hi Tresesco ! I did I'm unable to send the file which is Zip.can u please share your mail ID.