How to implement a Filter to filter Invoices with amount >, =, < certain value entered by user?

Hi Nourhan,

Yes it is possible to do so.

You can add your filter in the knowledge model and enable the same in the new views. You can build your filter as this :

FILTER table.col > 1025 OR FILTER table.col >1000;

Filtering in new views : Link

Hope this works for you!

Best,

Riddhi

But this way i will need to add the value myself in the KM. But the user wants to enter the value by herself. This value could by any value 1000 or 8765 or any value that i don't know.

Is that possible?

Hi Nourhan,

Yes you can use variables for the same. Use an input box and assign variables to that input box. The formulas which have those variables will get updated and display the answer.

For eg :

your filter will be -

FILTER table.col > variable1 OR FILTER table.col > variable2 ;

your input box will be configured to variable 1 and another for variable 2 for the user to input their value.

the formula where you want to use the variables where you want to use the input will have the variables instead of hardcoding the values.

Best,

Riddhi

Hi Riddhi,

Thank you for your answer!

I tried to do it as you mentioned but it gives me invalid filter syntax. This is the sentax that i use

FILTER KPI("invoice_value_") >= ${low_value} AND KPI("invoice_value_") <= ${high_value}

Everytime i add a variable, it gives the same error, it only works when i add a number in the filter such as

FILTER KPI("invoice_value_") >= 100 AND KPI("invoice_value_") <= 500

Am I using the wrong syntax or it does not work with variables?

Thank you in advance!