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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating an expression - error

Hi,

Table should look like this:

Date

No

Loss

%

12/02/2013

652

-152352

=LOSS/sum(CBBC)

CBBC field is loaded from a database.

Loss and %  are expressions and other fields are dimensions. At the moment, all the data is displayed fine apart from the calculated field where (–) is displayed rather than percentage. In the example above it should show a percentage, something like 3.05% for example.

How do I display the result for % field?

Hope this makes sense.

1 Solution

Accepted Solutions
Not applicable
Author

I used set analysis and I think it gives me the right result:

fabs((LOSS)/sum({1<SC_NO=>}total CBBC))

Thanks for the help, really appreciate it

View solution in original post

8 Replies
Not applicable
Author

Hi,

Try this num((LOSS_OVER_IM/sum(CBBC)),'#0%')

Not applicable
Author

Tried them both and still nothing... Only - displayed.

Loss  field is min(loss)

If i create a text object showing the calculation min(loss)/sum(CBBC), then it shows a result. If it's loss/sum(CBBC), then only - shows up.

However when I put min(loss)/sum(CBBC) in the actual straight table, nothing shows up

Not applicable
Author

Please Attach your application.

Not applicable
Author

I attached the application. Data is scrambled. Thanks

Not applicable
Author

Any ideas?

Not applicable
Author

Thanks.

If I choose a different scenario, then it's not displayed again. I need to display the biggest loss for a selected scenario.

Could you also explain how does TOTAL work?

Not applicable
Author

CBBC would be the same value for all the scenarios though.

Is it possible to set it so that if I choose another scenario with a different loss data, it would be divided by the same sum(CBBC) value? Somehow to 'unlink' CBBC from Scenario No so that it would not be affected if i choose a different one?

Not applicable
Author

I used set analysis and I think it gives me the right result:

fabs((LOSS)/sum({1<SC_NO=>}total CBBC))

Thanks for the help, really appreciate it