topic Re: expression is not working in straight table? please help in QlikView

expression is not working in straight table? please help

Tue, 16 Jun 2015 15:32:34 GMT

Hi,

I have below expression in straight table

expression 1=IF(ISNULL(Amount)=0,Amount,Amount) --- not working

when I used this the data is not showing in columns. when I used Amount in list box it is showing blanks at the top.

I have used the expression 2 with different column name as below which is working fine.

expression 1=IF(ISNULL(SalesAmount)=0,SalesAmount,SalesAmount) --- working fine

Only expression 1 is not working.

Please can anyone suggest me is there any wrong in expression 1?

Thanks.

Re: expression is not working in straight table? please help

swuehl — Tue, 16 Jun 2015 15:42:53 GMT

An expression should be conctructed using aggregations functions like sum() etc.

If you don't do that, your expressions return NULL when there is not a single, unambiguous result.

In your expression, if field Amount has more than one possible values in the context of current selections and dimensions, you won't get a result.

And why are your THEN and ELSE branch identical?

Re: expression is not working in straight table? please help

Wed, 17 Jun 2015 10:50:03 GMT

I have tried below not working

=Sum(Amount)

please help me how to change the above expression?

Re: expression is not working in straight table? please help

swuehl — Wed, 17 Jun 2015 10:52:34 GMT

What do you mean 'not working'?

No result ('-'), zero or wrong result (based on what definition of wrong)?

Have you checked that your values in field Amount are numbers, not text values?

Re: expression is not working in straight table? please help

PrashantSangle — Wed, 17 Jun 2015 11:17:23 GMT

Hi,

Try this

Sum(If(len(trim(Amount))=0 or isnull(Amount),Amount,Amount))

Regards

Re: expression is not working in straight table? please help

hariprasadqv — Wed, 17 Jun 2015 11:24:20 GMT

Hi,

ISNULL returns TRUE or FALSE. Instead of that you can use NULLCOUNT().

Re: expression is not working in straight table? please help

Wed, 17 Jun 2015 11:26:26 GMT

Thanks. I found the problem. I have added in script in link table as below

'' as Amount

I believe that caused the problem.

now I removed it and can able to see values in column.

Re: expression is not working in straight table? please help

Wed, 17 Jun 2015 11:26:43 GMT

Thanks.

Re: expression is not working in straight table? please help

Wed, 17 Jun 2015 11:26:49 GMT

Thanks.