topic Re: Hi Friends in QlikView

Hi Friends

krishna20 — Mon, 23 Jun 2014 04:59:28 GMT

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)))

Re: Hi Friends

tresB — Mon, 23 Jun 2014 05:08:33 GMT

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.

Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 05:26:50 GMT

=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.

Re: Hi Friends

Mon, 23 Jun 2014 05:28:05 GMT

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

Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 05:33:43 GMT

Hi Ram,

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

Re: Hi Friends

tresB — Mon, 23 Jun 2014 05:38:12 GMT

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.

Re: Hi Friends

sasikanth — Mon, 23 Jun 2014 05:40:56 GMT

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)

Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 06:19:13 GMT

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

Re: Hi Friends

tresB — Mon, 23 Jun 2014 06:21:21 GMT

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

Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 06:39:08 GMT

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

Re: Re: Hi Friends

tresB — Mon, 23 Jun 2014 06:50:34 GMT

Click on Reply->Use Advanced Editor (top right corner)->Attach (bottom right corner)

Re: Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 06:57:04 GMT

Re: Hi Friends

tresB — Mon, 23 Jun 2014 07:13:28 GMT

In your attached sample, the expression returns a value .235...

What is your expected result?

Re: Re: Re: Hi Friends

Mon, 23 Jun 2014 07:13:54 GMT

With tresesco's expression it is working fine. No nulls or anything.

Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 07:17:05 GMT

Commercial Min(TR_SI_LC1) MAX(TR_SI_LC_1) Min Rate Max Rate

42000 394000 2.17 5.15

52900 395000 2.33 5.05

50000 161774 2.48 3.18

all for 2014 year

Re: Hi Friends

krishna20 — Mon, 23 Jun 2014 08:11:19 GMT

Thank you..Tresesco..

Re: Hi Friends

tresB — Mon, 23 Jun 2014 08:26:24 GMT

Dear Kalyan,

If it is working for you, please close this thread marking it 'Correct Answer' and please delete this thread: Tresesco