dimension/mesure

[employe4_2]

HI

i'm blocking on something i dont understand how it works.

i got this situation: tsn (Numbers of identification) and a pressur associate with them.

i want to display a Line chart of my pressur function of that tsn number ( wich is unique for each pressur mesured)

As i try it ( right side of the image) it gave me only 0 as values, i check in  a tab and notice i only get 0 for every pressur when i define them as "mesures" and get the proper value when defined as "dimension".

How can i get it right ( my dimension should be my tsn and my mesure is my pressur)

[OmarBenSalem · Accepted solution]

I think that Qlik is defining ur field as a string and not a number.

to be sure, see if u add it as a filter:

if the values are in the right positions, it's numbers:

if they're on the left side, it's string:

try to convert it into a number:

try :

Num#(field,'0.0') as newfield

or

Num(field,'0.0') as newfield

or

num(Num#(field,'0.0')) as newfield

and then use use this new field as a measure

[employe4_2]

thanks man it was indeed a string var