How to get values without blanks

[#1]

Hi,

I have straight table with Team as dimension and Count(ID) as expression showing 3456 rows with blanks. Without blanks I have 500 rows. How can I change expression to show values only with out blanks.

i tried supressing the values but it's not wiorking.

can anyone let me know please.

Thanks.

[MK_QSL]

Try something like below...

T1:

Load * Inline

[

Product, Sales

A, 100

B, 10

C, 5

D, 50

, 40

F, 300

];

NoConcatenate

Load *  Resident T1

Where Not IsNull(Product) and Product <> '';

Drop Table T1;

[jonathandienst]

Hi

Suppressing zeroes only works if all expressions return a zero value. Assuming you want to suppress the row if expression 1 is blank, then do this for the other expressions:

     =If(Len(Column(1)) = 0, 0, <existing expression>)

And of course ensure that suppress zero values is checked.

HTH

Jonathan

[MK_QSL · Accepted solution]

You can use below in Load Script...

If(Len(Trim(ID))>0,ID) as ID

[sunilkumarqv]

Go to chart properties numbers tab change the number format settings exs: Fixed To:(#,##.#):(#,##.#);

[Peter_Cammaert]

Or use Column labels (to avoid errors when repositioning) and a NULL() result that makes the IF() simpler, e.g.

  =IF(len(trim(ColumnLabel1)) > 0, ExpressionColumn1)

In this case, ColumnLabel1 should be replaced with the label of the column whose expression decides on visibility.

Peter

[#7]

Thanks and it's working.