Straight Table Data selection

hkg_qlik — Thu, 13 Jan 2011 01:53:44 GMT

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,

Straight Table Data selection

johnw — Thu, 13 Jan 2011 02:04:39 GMT

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.

topic Straight Table Data selection in QlikView

Straight Table Data selection

Straight Table Data selection