topic How to make a selection inside a dinamic table? in QlikView

How to make a selection inside a dinamic table?

rcandeo — Mon, 12 Apr 2010 18:53:20 GMT

I have a dinamic table that brings to me the debit of my clients, grouped by a condition.

I want to show only the debits wich value grouped, be bigger than $ 10.000.

I´ve create a variable and a input field, so my user can put the value that he wants as a condition.

But I don't know how to discard the lines wich debits grouped be less than the variable created. Is there a way to do that inside a dinamic table?

How to make a selection inside a dinamic table?

Oleg_Troyansky — Mon, 12 Apr 2010 20:22:05 GMT

I guess by dynamic table you mean a Chart with the Clients and the calculated Expression of the Debt...

To keep things simple, you can use a setting "Searcheable" for the Expression (unless it's a Pivot Table, you can do it in Presentation tab). That would allow your users to "search" within the results of your calculated Expression.

The more complex solution would involve adding a set analysis condition that would only select those Customers that have their aggregated Debt higher than the value of the variable. Something like the following:

sum( {< Customer = {"=sum(Debt)>=$(myDebtVariable)"}>} Debt)

cheers,

How to make a selection inside a dinamic table?

rcandeo — Tue, 13 Apr 2010 13:38:42 GMT

I think set analysys is the better way, but I made a mistake cause didn't work. Can you help me what can be wrong in the expression please?

if(sum(aggr(Valor_Bruto,Filial,Documento,Codigo_Fornecedor,Nota,Valor_Pagamento,Chave_Pagamento))>Valor_Minimo,sum(aggr(Valor_Bruto,Filial,Documento,Codigo_Fornecedor,Nota,Valor_Pagamento,Chave_Pagamento)),0)