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

sum (values0*value1) question

Dear All,

i am having some issues with following situation, data table:

namepricerate
110000,5
220000,5
320000,9

I am trying to use expression in chart, to have total amount of rows, which is equal to price*rate. I am ussing expression SUM (price*rate), which gives me totaly wrong results.

Any suggestions?

Thanks!

9 Replies
Not applicable
Author

Your rate is having a comma instead of decimal....so it is not a number anymore.

Thanks,

Singh

d_pranskus
Partner - Creator III
Partner - Creator III

Hi

Please attach your file

Thanks

Anonymous
Not applicable
Author

Hi!

Take a look on the attached file.

Regards,

Gabriel

Not applicable
Author

Hi, in Lithuanian Locale it is numeric field. thanks

Not applicable
Author

this works, but if I create one chart like this (table), i want to create other chart (bar graph) which uses sum of these Value 2 fields. And I cannot select this expression.

Formula in Value1 - shows incorect results.

Not applicable
Author

files attached.

Anonymous
Not applicable
Author

Hi!

I've changed a few things. Take a look again, please.

Regards,

Gabriel

Not applicable
Author

no luck.

please see updated file, also with some examples of calculation in .xls sheet 2

d_pranskus
Partner - Creator III
Partner - Creator III

Hi

Expression should be as follows SUM(untaxed_amount_cache / rate)


See attached

Cheers