Convert data type text to string qliksense

[Aspiring_Developer]

Hello All,

I have below table :-

Now , I need to take the sum and count of the above field. But when I am trying to take sum it is giving me 0. I thought that field might be in text so I used num# (OPEN_WKG_DAYS) as OPEN_WKG_DAYS . But still the sum is coming 0 .

Not sure why   ? Can anyone please help ?

Thanks in advance

[salonicdk28]

Can you please help with the sample data which you are using here

[Aspiring_Developer]

Hi, Here is the dataset being used

[Aspiring_Developer]

Can  anyone please help me on this ?

[Aspiring_Developer · Accepted solution]

Hello All,

I was able to do it using below :-

num(num#(OPEN_WKG_DAYS)) as OPEN_WKG_DAYS

Thanks to @swuehl . I was able to find the solution in one of his post .Here is the link :-

Solved: Convert Text to Number - Qlik Community - 488687