Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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.