Qlik Community

New to Qlik Sense

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
markusblaut
Contributor III
Contributor III

Upload error with %-valus

Dear all,

following problem:

I have data in a txt format. the data will be uploaded in a cloud and the qlik webversion gets the data from the cloud.

 

In the data manager I can see the % values correct (see the column "CostOverru...") so I think the upload works.

Unbenannt.PNG

But if I want to creat a diagram with the dimension "costOverru...") all the values are zero or does not show up at all. 


Unbenannt2.PNG

Does anyone has an idea why this is not working?

 

Many thanks!

 

Markus

2 Replies
dplr-rn
Partner
Partner

From the screenshot it looks to me that you are using CostOverru as a measure . ( I see sum(CostOverru) in y axis)
as this is a text field it will not work.
suggest you convert the column to number or create another derived column on load which is numeric
bhargav_bhat
Creator II
Creator II

Hi Markus,

You can try below in the script for the column
if (replace(costoverrun,'%', '')<>'No FC!',replace(costoverrun,'%', '') ) as costoverrun

Regards,
Bhargav