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

Calculated Expression Error

Hi,

% of DF is a calculated expression but it does not work. It contains the following:

=LOSS_OVER_IM/sum(CBBC)

CBBC is loaded from the database. Why is the calculation not working?

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Information is not enough. Can you upload sample.

There will be lot of reasons for that issue.

Not applicable
Author

Sorry, I attached the table in original message but for some reason it didn’t show up.

Table should look like this:

Date

No

Loss over IM

% of DF

12/02/2013

652

-152352

=LOSS_OVER_IM/sum(CBBC)

CBBC field is loaded from a database.

Loss over IM and % of DF are expressions and other fields dimensions. In the calculated field only (–) is displayed rather than percentage.

Hope this makes more sense now.