topic Re: Chart Field Expression Error/Message in QlikView

Chart Field Expression Error/Message

Tue, 08 Jul 2014 18:07:30 GMT

Message:

You have attempted to apply a numerical expression, which is not uniquely defined for the specific variable. In order to use this variable in expressions relying on number of occurrences, please read it a second time under a new name from its primary table.

What does it mean to "... read it a second time under a new name from its primary table."?

I am getting this message when creating a Chart Field Expression to sum order totals using dimension of 'state' in from an orders table.

Re: Chart Field Expression Error/Message

hic — Tue, 08 Jul 2014 19:17:16 GMT

You have tried to create an expression Sum(OrderTotal), but since OrderTotal is a key, QlikView doesn't know which table to sum in. Create the sum from a non-key!

And if you really want to sum OrderTotal, you need to load this field a second time, under a new name.

HIC

Re: Chart Field Expression Error/Message

Tue, 08 Jul 2014 19:47:38 GMT

Don't sum, count and etc. Key Fields !

The best advice in this case is to load second time key field and rename it.

The result when you sum key fields is look like the result when you have a Synthetic table in the data warehouse model in your application.

Example:

Table1:

Load

Test (KeyField)

Test as TestSum

............

Re: Chart Field Expression Error/Message

Wed, 09 Jul 2014 12:16:10 GMT

Thanks for you quick and accurate responses! As suggested I re-loaded the field under a new name as non-key and the expression is working now.

Re: Chart Field Expression Error/Message

Wed, 09 Jul 2014 12:35:36 GMT

You can see also this:

www.community.qlik.com/docs/DOC-5901

There are useful information.