Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
markusblaut
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.

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

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
bhargav_bhat
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

Regards,
Bhargav
Community Browser