Record filter

dhanavindhan — Thu, 22 Mar 2018 06:05:00 GMT

Hi Experts,

I want to apply filter by condition. Please see my image first,

ExportFree Days was my first option filter. Then I will choose the Exp free days is = (Less_than or Greater_than or Equal_To) from the dropdown select. From that conditonthe record should be filtered and need to be populated in the table. I don't know what type of expression i need to write and how to apply that to filter the records. Can anyone help me to fix this issue. Thankx in advance

Example:

If I choose 21 from then I choose Less_than 21 (It should bring records below 21 like (20,19,18,17,16,15...etc on the table.

Regards,

Dhana R

Re: Record filter

shiveshsingh — Thu, 22 Mar 2018 06:45:41 GMT

Can you share your app?

You need to create 2 variables which will be having values from your Listbox or input box

Then use that variable in your set expression

like Sum({<Day-= {"$(=VariableName)"}>}Sales) - - - Please keep in mind the formatting.

topic Record filter in QlikView

Record filter

Re: Record filter