topic Syntax problem i calculation in QlikView

Syntax problem i calculation

Mon, 19 Apr 2010 08:00:02 GMT

I´m trying to do this calculation in a list caption:

I have a list that looks like this

2008 1000

2009 1500

the 1000 and 1500 is the frequency

=sum(sales=''2009) - sum (sales='2008')/sum(sales='2009')'100 & '%'

this should give me an increase percentage - but the resultgives me the number - 150268 ???????????

Syntax problem i calculation

Mon, 19 Apr 2010 08:24:17 GMT

Hi Polschou,

Pls try the below syntax;

Num(((Sum({$<YEAR={2009}>} Value)-Sum({$<YEAR={2008}>} Value)) / Sum({$<YEAR={2009}>} Value)),'#0.00%')

Regards

Rajesh

Syntax problem i calculation

Mon, 19 Apr 2010 09:10:41 GMT

Hi Rajesh

sorry it doesnt work - gives no result

I worked a little further with my own and it works now like this

=((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009'))'100 & '%'

The only problem now is that the result shows the percent like thsi 31,1234567899%

I only want 1 place after the comma - like this 31,1 %

Syntax problem i calculation

Mon, 19 Apr 2010 09:18:49 GMT

Hi,

Can you try to add number format infront for your calculation.

Eg. Num(<<expression>>, '#0.00%') - take out the 100 & % from the expression.

Regards

Rajesh

Syntax problem i calculation

Mon, 19 Apr 2010 09:45:11 GMT

I tried like this

=Num(((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009'))'100),#0.00% & '%'

but it doesnt work

Syntax problem i calculation

Mon, 19 Apr 2010 09:55:01 GMT

Try this.

=Num(((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009')),'#0.00%')

Syntax problem i calculation

Mon, 19 Apr 2010 09:59:31 GMT

why don't you use "Number" tab for formatting?.This will solve your problem

Syntax problem i calculation

amars — Mon, 19 Apr 2010 10:04:06 GMT

Try

= sum(If(sales='2009',Value)) - sum (If(sales='2008', Value))/sum(If(sales='2009',Value)) * 100

Syntax problem i calculation

Mon, 19 Apr 2010 10:14:25 GMT

I just get a - so it doesnt work either 🙂

Syntax problem i calculation

Mon, 19 Apr 2010 10:15:31 GMT

ramchander - using number for formatting only changes the formaat in the list not in the caption

Syntax problem i calculation

Mon, 19 Apr 2010 10:21:19 GMT

Hi amars - doesnt work - gives no result

Syntax problem i calculation

Miguel_Angel_Baeyens — Mon, 19 Apr 2010 10:24:20 GMT

Hello,

Use Num() function as follows:

Num(your sum expression here, '#0.0 %')

which will return only one decimal.

Syntax problem i calculation

Mon, 19 Apr 2010 10:28:07 GMT

Hi,

can you share the application with limited data or dummy data.

Regards

Rajesh

Syntax problem i calculation

Mon, 19 Apr 2010 10:28:40 GMT

Hi You all guys

You gave me inspiration to work it out and I works for me like this

=left((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009'),5)'100 & '%'

this gives me 31,7%