topic Convert data type text to string qliksense in App Development

Convert data type text to string qliksense

Aspiring_Developer — Wed, 07 Sep 2022 08:45:05 GMT

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

Re: Convert data type text to string qliksense

salonicdk28 — Wed, 07 Sep 2022 11:29:51 GMT

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

Re: Convert data type text to string qliksense

Aspiring_Developer — Wed, 07 Sep 2022 12:47:00 GMT

Hi, Here is the dataset being used

Re: Convert data type text to string qliksense

Aspiring_Developer — Thu, 08 Sep 2022 06:41:13 GMT

Can anyone please help me on this ?

Re: Convert data type text to string qliksense

Aspiring_Developer — Thu, 08 Sep 2022 06:48:33 GMT

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