topic Re: Expression help! in QlikView

Expression help!

Fri, 14 Feb 2014 09:20:57 GMT

Hi,

I am trying to write an expression to calculate a pipeline of opportunities. For example I want to work out the ORDERVALUE if the PROB_DESC is = to 10% then multiply by 10%.

I have tried many different expressions but it doesn't seem to be working for me.

Re: Expression help!

MK_QSL — Fri, 14 Feb 2014 09:27:57 GMT

SUM({<PROB_DESC = {'10%'}>}ORDERVALUE)*10/100

SUM({<PROB_DESC = {0.1}>}ORDERVALUE)*10/100

Re: Expression help!

Fri, 14 Feb 2014 09:31:52 GMT

Tried, keeps returning a value of 0

Re: Expression help!

Sokkorn — Fri, 14 Feb 2014 09:41:24 GMT

Hi Sara,

What is value in field PROB_DESC look like? or can you upload your app?

Regards,

Sokkorn

Re: Expression help!

Fri, 14 Feb 2014 09:42:40 GMT

The code behind it is prb.001 etc but I have tried using that and it's still bringing nothing back.....

Re: Expression help!

Peter_Cammaert — Fri, 14 Feb 2014 09:49:22 GMT

Various little things can be wrong. Post an example document to help us in quickly finding the anomaly. Otherwise, the community has to start guessing, and that approach may take a while.

Best,

Peter

Re: Expression help!

Sokkorn — Fri, 14 Feb 2014 09:51:49 GMT

Hi Sara,

Are you do this yet

Sum({<PROB_DESC = {'prb.001'}>} ORDERVALUE)*0.1

Regards,

Sokkorn

Re: Expression help!

sundarakumar — Fri, 14 Feb 2014 09:56:53 GMT

Hi,

Pls post what an example to understand the requirements,

maybe this is what u look for

if(prob_desc=10,order_value*0.1,null()) as new_field

in edit script and sum all
new_field in the chart.

Atleast pls try to create a sample source, so that we can help.

-Sundar

Re: Expression help!

Fri, 14 Feb 2014 10:13:47 GMT

Hi,

If it is something that you will need to calculate for every register, then it should be done during the load phase in the load script as Sundarakumar is suggesting. This way the application will perform better.

Re: Expression help!

Fri, 14 Feb 2014 10:15:53 GMT

Perfect, will review the script and try from there!

Thanks for your help.