Issue with not yielding figures.

[#1]

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

[#2]

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.

[#3]

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

[martino]

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);

[#5]

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.

[martino]

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

[#7]

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

[martino · Accepted solution]

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