topic Re: How to get values without blanks in QlikView

How to get values without blanks

Mon, 03 Feb 2014 13:05:57 GMT

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.

Re: How to get values without blanks

MK_QSL — Mon, 03 Feb 2014 13:11:38 GMT

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;

Re: How to get values without blanks

jonathandienst — Mon, 03 Feb 2014 13:13:21 GMT

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

Re: How to get values without blanks

MK_QSL — Mon, 03 Feb 2014 13:15:23 GMT

You can use below in Load Script...

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

Re: How to get values without blanks

sunilkumarqv — Mon, 03 Feb 2014 13:20:40 GMT

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

Re: How to get values without blanks

Peter_Cammaert — Mon, 03 Feb 2014 13:23:28 GMT

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

Re: How to get values without blanks

Mon, 03 Feb 2014 13:27:59 GMT

Thanks and it's working.