Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
New 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.


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


Does anyone has an idea why this is not working?


Many thanks!



2 Replies
Valued Contributor III

Re: Upload error with %-valus

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
Contributor II

Re: Upload error with %-valus

Hi Markus,

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

Community Browser