topic Re: Compare Value between Interval into a Table in QlikView

Compare Value between Interval into a Table

Wed, 25 Nov 2015 20:46:22 GMT

Hello.

I hope I'll get help from here.

I have a table as follows:

The idea is: when I use a InputSum and insert, for example (-7) the table should filter and be like this:

Also I want to save the unique value returned using a Variable, I am sure it would return just one row (and value).

Because (-7) is into the range from (-8) to (-5.1).

Thanks for the help.

Re: Compare Value between Interval into a Table

t_chetirbok — Thu, 26 Nov 2015 07:28:31 GMT

Hello!

Use the straight table with dimensions "category","Date","RangeFROM","RangeTO" and expression only({<FROM={">=$(InputSum)"},TO={"<=$(InputSum)"}>}VALUE)

where InputSum is your variable

Re: Compare Value between Interval into a Table

Anonymous — Thu, 26 Nov 2015 07:40:53 GMT

How you are getting (-7)??

Is it a field or variable? Did you try with intervalmatch()?

Re: Compare Value between Interval into a Table

Thu, 26 Nov 2015 15:29:14 GMT

Hello, (-7) is a calculated value or an inputsum.

I used Intervalmarch in script, so I want a similar function but in a pivot or simple table.

I am trying to simulare scenarios, and I am using inputsum(fieldQTY) and inputsum(fieldPRICE), make calcs, etc. and compare the result value with those ranges to funally get the VALUE and save it into a variable.

Re: Compare Value between Interval into a Table

Thu, 26 Nov 2015 20:37:42 GMT

Hello Tatsiana, I think you've got my Idea. I´m doing all your instructions, but the result straight table is empty.

Would you please help me with more information about what i'm doing wrong.

Here in the link i have the application and the QVD.

sim_qvw_qvd

Re: Compare Value between Interval into a Table

t_chetirbok — Fri, 27 Nov 2015 06:12:44 GMT

Hi!

You compare negative numbers, your expression must be

only(

{<SimRangoDesdeCosto="<=$(vInputSum)"}, SimRangoHastaCosto=">=$(vInputSum)"} >}

SimCostoPrecioPorcentaje)

If you'll compare positive numbers your set analysis look like {<SimRangoDesdeCosto=">=$(vInputSum)"}, SimRangoHastaCosto="<=$(vInputSum)"} >}

Re: Compare Value between Interval into a Table

Tue, 01 Dec 2015 16:51:24 GMT

Thank you for your help.