Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter Condition

How to Add a filter for: Margin > X and Margin < X

13 Replies
Not applicable
Author

In script, use IF clause.

If you have a field "MARGIN", just put in a list box which you can use as a filter.

Regards,

sebablum

Not applicable
Author

How can I provide range? and how do i pass it to report?

Not applicable
Author

Do you have the margin in your data or is it a scripting matter? If you send a qvw-file it will be much easier to understand your needs.

Not applicable
Author

Margin needs to be calculated as

Revenue - Cost

Not applicable
Author

In the load script, you can use

Revenue - Cost AS Margin;

Then you get the margin as a field. Pls find attached a QVW showing use of the listbox (Margin is generated as load inline in the example).

/sebablum

Not applicable
Author

How can I provide range? Less than greater than range?

Not applicable
Author

Just mark more than 1 value in the list box by CTRL + click. If this is not what you want to know, I do not understand your problem, I am afraid. If this is the case, please describe your problem and attach an application showing its core.

hic
Former Employee
Former Employee

If you have your margin in a field, then you can write a search string '>100<500' (without the quotes) which will give you the range 100-500.

Not applicable
Author

User will input Margin range like From = 100 and To = 500

Report data will be filtered for this range.

So the value 100, 500 is not hard coded and is based on user input.

any ideas how i can achieve this?