topic search box with expression in QlikView

search box with expression

Thu, 14 Mar 2013 12:59:40 GMT

I would like to put this expression in a search box, but it didn't work.

It returns me the date that my truck will come back. And I need to filter my table through the date that this expression gives me.

In a graph it work very well but I need it in the search box.

=Floor((max(aggr(max(Distancia),Veículo,[Código Instrução Filial]))/550)+max(aggr(max([Previsão Entrega]),Veículo,[Código Instrução Filial])))

When I put it in a List for exemp... it returns me the aggr of all dates, If I put a dimension in a list with this expression, works, but I can't filter by the expression.

Thank you

Re: search box with expression

kaushiknsolanki — Thu, 14 Mar 2013 13:18:40 GMT

Hi,

instead you can create a button to execute this expression and then select the resulted value from date field.

All you need to do for this is, Add action on button click to select the value from field.

and then in search string area you can put this expression.

Regards,

Kaushik Solanki

Re: search box with expression

Thu, 14 Mar 2013 14:26:11 GMT

The last column on the table is the expression working. Who will see it need to know how many trucks will come back 'today' for example. But there's a lot of trucks that will arrive today, in many different hours, so I need to put this expression to select just one day and see what are the trucks that will arrive 'today' or 'tomorrow'

Re: search box with expression

Thu, 14 Mar 2013 14:32:02 GMT

hi,

Will you please upload the sample application

Re: search box with expression

Thu, 14 Mar 2013 16:55:59 GMT

The file is very big.

Try it.