topic How to replace 0 (Zero) values with ' ' (Blank) in a Table Box column? in QlikView

How to replace 0 (Zero) values with ' ' (Blank) in a Table Box column?

SajjadQV — Sat, 16 Nov 2024 01:06:25 GMT

I've a Data file loaded/displayed in a Table Box where Quantity and Amount fields are holding values; but in some rows of these fields, Data are 0 (Zero) which are displaying as "0.00" in the Table Box columns. I want to show these "0.00" values as " " (Blank).

Sample current Table Box output is given in below snap-shot for ready reference:-

QlikView Table Box - Zero Value to Replace with Blank

How this can be achieved? Any help. Thanks in Advance.

Re: How to replace 0 (Zero) values with ' ' (Blank) in a Table Box column?

CJ29 — Mon, 09 Mar 2020 04:01:24 GMT

Since a table box does not allow expressions, I reckon you will have to do this in the script.

Something like

if(A=0,'',A) as A;

On the contrary, you can use a straight table for the same purpose. That way you won't have to do it in Script (Not advisable to make a measure as blank.

What you can do is, pull all the required fields in the dimensions and in Expressions say =1. Then in the presentation tab hide the expression field. You will be able to achieve the same granular table as before.

Regards

Re: How to replace 0 (Zero) values with ' ' (Blank) in a Table Box column?

SajjadQV — Mon, 09 Mar 2020 18:32:18 GMT

Thanks CJ29. It's works fine. Thanks for your solution.

Regards.