topic Re: Filter Condition in QlikView

Filter Condition

Thu, 02 Feb 2012 10:59:11 GMT

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

Filter Condition

Thu, 02 Feb 2012 11:05:53 GMT

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

Filter Condition

Thu, 02 Feb 2012 11:13:44 GMT

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

Filter Condition

Thu, 02 Feb 2012 11:18:19 GMT

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.

Filter Condition

Thu, 02 Feb 2012 11:20:59 GMT

Margin needs to be calculated as

Revenue - Cost

Re: Filter Condition

Thu, 02 Feb 2012 11:28:11 GMT

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

Filter Condition

Thu, 02 Feb 2012 11:45:32 GMT

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

Re: Filter Condition

Thu, 02 Feb 2012 12:28:16 GMT

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.

Filter Condition

hic — Thu, 02 Feb 2012 12:53:19 GMT

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.

Filter Condition

Fri, 03 Feb 2012 11:13:49 GMT

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?

Filter Condition

hic — Fri, 03 Feb 2012 11:28:17 GMT

The proper way to let users set filters in QlikView is to let them click in a list box. If there are too many values in the Margin list box, then you can create an extra field in the script, e.g.

class( Margin,100 ) as MarginClasses

Filter Condition

Fri, 03 Feb 2012 11:33:10 GMT

I tried as below:

1. create 2 input boxes. One for From and second for To value

2. Then in expression: I have

sum( {$<Margin = {"<=$(vTo)>=$(vFrom)"}>} Margin)

This is not working as desired although it filters some data in report.

Any idea whats wrong in this expression?

Filter Condition

Fri, 03 Feb 2012 11:43:04 GMT

class( Margin,100 ) as MarginClasses

above statement is giving error.

Margin is calculated as Revenue - Actual

Filter Condition

Fri, 03 Feb 2012 12:35:57 GMT

Can someone suggest why below expression is not working?

sum( {$<Margin = {"<=$(vTo)>=$(vFrom)"}>} Margin)

where vTo and vFrom are variables