Filter the row based on user input through inputbox

prasoon92 — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have created a variable velapse and initiated it's value with 1500.

I have used this value in input box as a default value and used this input box here for user to change this value as per thiet need.

Now I want to filter the row from a pivot table based on user input.

So for above requirement I have a text object and In select in field I have given Jobname and search string I am pass as below.

='('& Concatenate(If(Elapsedseconds>=

$(velapse) , ' " '&JobName' " '),'|')&')'

I am getting only three jobs meeting above condition but there are more entries in the table that should meet above condition.

Did anyone else face this issue?

Regards,

PRASOON

topic Filter the row based on user input through inputbox in QlikView