Converting text data type into num qliksense

Aspiring_Developer — Wed, 30 Mar 2022 07:57:05 GMT

Hello all,

I have below table:-

I am trying to do the sum of closed_wkg_days but it is coming 0 . When I take the count it populates the number.

I am assuming that data type of my field is in text format . Hence, in the backend script I used num(closed_wkg_days) but it did not worked.

Can anyone please help me with this ?

Thanks in advance

Re: Converting text data type into num qliksense

brunobertels — Wed, 30 Mar 2022 10:11:34 GMT

try with num#(closed_wkg_days)