topic Re: Sentence With Script in QlikView

Sentence With Script

pgalvezt — Fri, 30 May 2014 21:43:12 GMT

Hi,

I have this

Load

[conA1 ] + [conB1 ] as TotalSum

From Table1;

My Expression Sum(TotalSum) thrown 5000

but I want to add an if sentence

Load

If([conA1 ] + [conB1 ] >0,'0', [conA1 ]+ [conB1 ])

as TotalSum,

From Table1;

My Expression Sum(TotalSum) thrown 4900

I need to appear 5000

How Could it be?

Thanks!

Re: Sentence With Script

eduardo_sommer — Fri, 30 May 2014 21:53:40 GMT

You probably inverted the then/else in the if

Try with:

if([conA1 ] + [conB1 ]>0,[conA1 ]+[conB1 ], 0) as TotalSum,

Eduardo

Re: Sentence With Script

pgalvezt — Fri, 30 May 2014 22:05:11 GMT

Hi Eduardo,

Still gives the same total 4900,

Thanks

Re: Sentence With Script

eduardo_sommer — Fri, 30 May 2014 22:20:03 GMT

Can vou share your qvw or at least part of it?

Eduardo

Re: Re: Sentence With Script

pgalvezt — Fri, 30 May 2014 23:24:51 GMT

Eduardo,

The real result is -4714

The wrong result is 4874

Thanks!

Re: Sentence With Script

eduardo_sommer — Sat, 31 May 2014 01:39:52 GMT

When I tried to open the app, it asked for a userid and password. Please, disable Section Access.

Eduardo

Re: Sentence With Script

Joseph_Musekura — Sat, 31 May 2014 06:57:37 GMT

Hi,

Can you verify if, in the property of expression in you have checked Expression Total or Sum of rows?

This selection would affect the result

regards,

Re: Sentence With Script

Joseph_Musekura — Sat, 31 May 2014 07:00:03 GMT

I did not mention that this concerns "straight table". If you have a pivot table , no need to check.

Re: Re: Sentence With Script

pgalvezt — Mon, 02 Jun 2014 13:59:37 GMT

Im Sorry,

Section Access was deleted,

Thanks!

Re: Sentence With Script

eduardo_sommer — Mon, 02 Jun 2014 14:35:41 GMT

Good morning , Pablo

Why do you use Consumo12 in one object and Consumo12a in the other. The object with Consumo12a is giving you the result you expected.

Please, send me more details, since I don't have the data sources.

Eduardo

Re: Sentence With Script

pgalvezt — Mon, 02 Jun 2014 14:40:29 GMT

Good Morning,

The real object is the if sentence, the other one (Consumo12a) is for check the real result. I don´t know why when I use If the final result change in the script.

Re: Sentence With Script

eduardo_sommer — Mon, 02 Jun 2014 14:59:21 GMT

You have some positive values in the inv-consumoso12 field, with zero in the corresponding inv-consumowo12. According to your if statement, when the sum of inv-consumoso12 plus inv_consumowo12 is positive, ignore them, changing the result to 0. This gives the difference in the results.

For the product PV04IM-32-9928 that came selected in your app, inv-consumowo12 is 0 for all rows and inv-consumoso12 has some positive values.

Eduardo

Re: Sentence With Script

pgalvezt — Mon, 02 Jun 2014 15:21:14 GMT

I understand that, so how could be the best if sentence and give 4714?

Thanks!

Re: Sentence With Script

eduardo_sommer — Mon, 02 Jun 2014 16:32:33 GMT

Hi Pablo,

I think I'm missing something in this question. You have an expression to calculate a field, called Consumo12a, which gives you the right result. This expression has no if. It simply makes the sum of two fields. Why do want to achieve, in the calculation of Consumo12, with that IF. Excluding the positive sums gave you the wrong results. Maybe you don't need that if and use the same expression as that of Consumo12a.

Please, tell me what I'm getting wrong from your question.

Eduardo

Re: Sentence With Script

pgalvezt — Mon, 02 Jun 2014 17:12:44 GMT

I did the follow:

If(Sum(Consumo12) < '0','0',Sum(Consumo12))+Sum(Despacho) Now Works for that expression.

I just I have to change all Consumo12 ,11 and 10 for that expression.

Thanks Eduardo. I marked your suggestion as better answer.