topic Re: Search by expression in staight table in QlikView

Search by expression in staight table

Tue, 26 Mar 2013 13:04:22 GMT

Hi,

I have a straight table with dimensions and expressions and now i need to search by one of them. I have tried to make a listbox with the expression and not getting the desired result in the table. The function "searchable" also doesnt work as desired when i have so many dimensions.

The expression in the table that i want to search by is:

(sum(Income)

sum(rangeonly(if(CostDate>=IncomeDate_from and CostDate<=(if(isnull(IncomeDate_to), 'vToday', IncomeDate_to)),TotalCost))))

sum(Income)

This expression gives a result between 0 and 1, I would like to have a listbox with the alternatives 0-0,2 & 0,2-0,4 & 0,4-0,6 and so on.

/Majkel

Re: Search by expression in staight table

alexandros17 — Tue, 26 Mar 2013 13:11:17 GMT

You can do a "fake" list box by creating a straight table with only the expression you want to use ... and use this object as a list box showing all values of the expression

It's an idea, hope it helps.

Re: Search by expression in staight table

agigliotti — Mon, 11 Nov 2013 15:55:26 GMT

Ciao Alessandro,

in relazione a questo thread, ti sottopongo un'anomalia che ho riscontrato riguardo la ricerca su un'espressione in una Straight Table.

io sto utilizzando la versione 11.20 SR4 (build 12129)

semplicemente quando eseguo una ricerca es. >=500 mi vengono filtrate correttamente le righe della tabella ma rimangono alcune che non soddisfano la ricerca impostata (<500).

Quindi sembra essere un bug...

Hai avuto occasione di verificare questa funzionalità ?

Rimango in attesa di un tuo gentile riscontro.

Grazie.

Saluti