Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax problem i calculation

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

13 Replies
Not applicable
Author

Hi amars - doesnt work - gives no result

Miguel_Angel_Baeyens

Hello,

Use Num() function as follows:

Num(your sum expression here, '#0.0 %')
which will return only one decimal.

Not applicable
Author

Hi,

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

Regards

Rajesh

Not applicable
Author

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%