topic Table Chart Conditional Column Question in QlikView

Table Chart Conditional Column Question

Wed, 19 May 2010 12:15:09 GMT

Hi,

I'm having problems using Conditional. e.g. I use a simple table with customers and sales. If I only want to show the columns where sales > 100 I would use "sum(Sales)>100". Unfortunately this isn't working. Someone an idea. Thanks.

Aloah

Table Chart Conditional Column Question

Wed, 19 May 2010 13:15:54 GMT

Hi,

This seems to be a duplicated thread, and I sent the following reply to your last thread, did you get it? Did you try it?

Sum(Sales) would be evaluated on a Row Level, so I don't suppose it would work as a condition to switch off a column.

What is it exactly that you're trying to achieve? If you are simply trying to exclude a customer from the table if the sales is less than 100 then you should do this in your expression, not on a conditional show. Your expression currently is probably Sum(Sales), if you'd like to exclude as I said above then change your expression to =IF(Sum(Sales)>100,Sum(Sales)), this should do it for you.

If my assumptions are wrong, you need to let us know what you are really trying to achieve.

Regards,

Table Chart Conditional Column Question

Wed, 19 May 2010 14:49:11 GMT

Hello Nigel,

thanks for your help. I was compeltly wrong. Of course I need to do this in the expression.

Table Chart Conditional Column Question

Wed, 19 May 2010 15:40:46 GMT

Hi Nigel,

is it possible to supress a complete line with all other expressions?

if table looks like this:

salesper | expr.1 (sum(sales)) | expr..2 (avg(sales))

if expr.1 <1000 the whole row should'nt be displayed.

thanks

Aloah

Table Chart Conditional Column Question

Wed, 19 May 2010 15:50:16 GMT

Hi Aloah

Expression 1 would be: =IF(Sum(Sales)<1000,Sum(Sales))

Expression 2 would be: =IF(Sum(Sales)<1000,Avg(Sales))

That should do it.