topic Re: Issue with not yielding figures. in QlikView

Issue with not yielding figures.

Wed, 20 Jun 2012 13:18:15 GMT

I am not getting any values in the K2 for half of the dimensions, why is that?

Re: Issue with not yielding figures.

Wed, 20 Jun 2012 13:24:28 GMT

hi,

in ur K2 expression, the "Solvensnivå" is underlined as red. Have u mentioned the right field name?

the expression is wrong in that case.

Or can u please translate the code in english.

Re: Issue with not yielding figures.

Wed, 20 Jun 2012 13:27:46 GMT

Solvensnivå is just a variabel I have in which is fixed to 0.9995 at this time.

Re: Issue with not yielding figures.

martino — Wed, 20 Jun 2012 13:37:41 GMT

Hi,

You might say that it is just a variable, but it is not a variable in your QV app.

The "Solvensnivå" is loaded from an Excelfile as in your script below..

Are there any values in the Excelfile for Solvensnivå ? as the field is not present in the QlikView Datamodel.

Try pressing "Ctrl + T" there you can se that the field does not exists in your datamodel.

LOAD Unik_ID,

Volum,

PD,

m3_PD,

Klasse,

m3_Klasse,

Korrelasjon,

Solvensnivå,

Avkastningskrav

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Issue with not yielding figures.

Wed, 20 Jun 2012 13:53:47 GMT

I have values in the solvency, and the value is exactly the same used in the calculation of the K value. The K value calculates perfectly while k2 does not. So there must be something with the other variable, the "Korrelasjon2" and its values.

Re: Issue with not yielding figures.

martino — Wed, 20 Jun 2012 14:00:27 GMT

Sorry, but it is no help.

If I unhide the K value so that it is showed in the Table it shows no values.. And the syntax in the expression is not correct. Nor can I se anything called "Solvency".

Think you have to be much more specific for if we are to help you.

Best regards

/Martin

Re: Issue with not yielding figures.

Wed, 20 Jun 2012 14:02:36 GMT

I have included a slightly different file , which I think proves my point?

Re: Issue with not yielding figures.

martino — Thu, 21 Jun 2012 13:42:01 GMT

I does not work because you have more than one "Korrelasjon2" value for the "m3_klasse" dimensions (A,B,C,Mislighold and uklassifisert)