Help with Expression

Anonymous — Thu, 20 Nov 2014 16:29:55 GMT

Hi guys,

I have data which has some null values. I have created a table box and I can view these records. As you can see within the table they are displayed as a dash "-"

What I would like to do is create a straight table which groups on some fields apart from the value because I would like to sum each order on value with an Expression. My problem when I do this though is that the records where there are NULL values are omitted from the table. I assume this is because the value cannot be summed? Problem is I would still like to show these records.

I have tried the following expression.

=IF(ticket_replacement_order_no <> 'NULL',sum(orders_val),orders_val = '0')

I am thinking if the field "ticket_replacement_order_no" is not null then sum the order value. Else set the order value to zero

Is what I would like to do even possible?!

Hopefully I have explained this ok!

Thanks v much

Re: Help with Expression

Thu, 20 Nov 2014 16:43:49 GMT

In a straight table you can only see demensions where there is a value in one of the expressions for it so what I do is add an expression with the value 1 and then Hide it.

Re: Help with Expression

Anonymous — Thu, 20 Nov 2014 16:57:44 GMT

OMG. That has worked ! I see I was massively over complicating this as this answer was simple...

Thank you very much Carly

topic Re: Help with Expression in QlikView

Help with Expression

Re: Help with Expression

Re: Help with Expression