4 Replies Latest reply: May 13, 2014 10:05 AM by Sebastian Schuler RSS

    QV interprets value wrong

    Sebastian Schuler

      Hey Community!

       

      I am facing a Problem where Qlikview doesn't Interpret a value as it should do. The Scenario is as follows:

       

      I have a value called CPK-WertAsIs. It looks like this:

      2,0109445532776422E+00

       

      I would like to transform this value into a number by eliminating the last 4 Digits. In the file attached, this value is called CPK-WertTransformed". With this value i would like to create normal bar Charts. Unfortunately QV always tells me: "No data to Display"

       

      I attached a file where you can see how it looks like. In the script you will see how i transformed the value. (i tried several different methods, not of it worked though...)

       

      I would really appreciate any suggestions!

       

      regards

      Sebastian