topic Re: Change - with '0' in QlikView

Change - with '0'

Thu, 25 May 2017 07:45:06 GMT

Hello All,

Thank you in advance for the support,In my APP i have one column related to the time in day, this value was not present for all the record and in case is not present i have the value '-' is possible change it with '0'? because i have other column with calculation and in this situation i have an error in this result, also in this column i have the value '-'.

Thank you very much.

Massimiliano

Re: Change - with '0'

Anil_Babu_Samineni — Thu, 25 May 2017 16:24:11 GMT

Can you show atleast image how data is looks like

Re: Change - with '0'

Anonymous — Thu, 25 May 2017 16:24:16 GMT

Hello Friend,

In my opinion best way will be add it to load script, could you send the code of that table from loading script?

Regards

Jacek.

Re: Change - with '0'

rwunderlich — Thu, 25 May 2017 17:19:13 GMT

alt(mytime, 0)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Change - with '0'

Fri, 26 May 2017 07:28:58 GMT

Hell All,

Thank you!! attached the script and the picture of the result.

SCRIPT:

TABLE:

What i'm talking about is the first column, for some row i have the value for other (not present in the table ) i have the - and if the value is not present another calculate column show the same character and not a number.

thank u very much and tell me if i can add something to explain better the situation.

Re: Change - with '0'

rwunderlich — Fri, 26 May 2017 16:33:56 GMT

What field or expression are you using for the first column?

-Rob

Re: Change - with '0'

Kushal_Chawda — Fri, 26 May 2017 17:47:04 GMT

alt(floor(max(pending_counter)/60/24)),0) as Max_Pending_Counter

Re: Change - with '0'

Tue, 30 May 2017 12:39:25 GMT

Hello Guys, thank you for your answear i've tried with your script but i have a strange "situation" now i have many row for one record and for all this row the "pending_counter" is a number:0-1-2-3-4 do you know why?