Straight Table Data selection

[hkg_qlik]

Hi,

I am comparing two values in a table Balance and Credit Limit. I have around 500 records for the same.

Now I want to construct another table where I only want to display those customers whose Balance is greater than Credit limit and create a Chart on the same.

Is it possible?

Thanks,

H

[johnw]

You could use a calculated dimension:

=aggr(if(Balance>CreditLimit,Customer),Customer)

But I don't like calculated dimensions because they've always been very slow for me. It is probably more efficient to use Customer as a dimension, and include the if() in every expression. So if you wanted the sum of sales to that customer, for instance:

if(Balance>CreditLimit,sum(Sales))

And then suppress nulls. Since you only compute values for customers with a balance higher than their credit limit, only those customer should show.