topic Re: Result not displayed when calculating an expression - error in QlikView

Calculating an expression - error

Thu, 14 Mar 2013 11:29:04 GMT

Hi,

Table should look like this:

Date

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.

Re: Result not displayed when calculating an expression - error

Thu, 14 Mar 2013 11:35:05 GMT

Hi,

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

Re: Result not displayed when calculating an expression - error

Thu, 14 Mar 2013 11:44:58 GMT

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

Re: Result not displayed when calculating an expression - error

Thu, 14 Mar 2013 11:47:00 GMT

Please Attach your application.

Re: Result not displayed when calculating an expression - error

Thu, 14 Mar 2013 12:33:18 GMT

I attached the application. Data is scrambled. Thanks

Re: Result not displayed when calculating an expression - error

Thu, 21 Mar 2013 09:50:47 GMT

Any ideas?

Re: Result not displayed when calculating an expression - error

Thu, 21 Mar 2013 10:45:44 GMT

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?

Re: Result not displayed when calculating an expression - error

Thu, 21 Mar 2013 10:59:14 GMT

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?

Re: Result not displayed when calculating an expression - error

Thu, 21 Mar 2013 12:53:32 GMT

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