Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
employe4_2
Contributor III
Contributor III

dimension/mesure

HI

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

Capture.PNGCapture2.PNG

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)

1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

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:

Capture.PNG

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

Capture.PNG

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

View solution in original post

2 Replies
OmarBenSalem
Partner
Partner

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:

Capture.PNG

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

Capture.PNG

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

View solution in original post

employe4_2
Contributor III
Contributor III
Author

thanks man it was indeed a string var