Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am not getting any values in the K2 for half of the dimensions, why is that?
I does not work because you have more than one "Korrelasjon2" value for the "m3_klasse" dimensions (A,B,C,Mislighold and uklassifisert)
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.
Solvensnivå is just a variabel I have in which is fixed to 0.9995 at this time.
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);
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.
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
I have included a slightly different file , which I think proves my point?
I does not work because you have more than one "Korrelasjon2" value for the "m3_klasse" dimensions (A,B,C,Mislighold and uklassifisert)