Comparing values and choosing the smaller value?

[Anonymous]

Hello guys,

So I have following Problem: i Need qlikview to look at two different rows from my data source and compare the values within. For further calculations in qlikview I Need it to find out the smaller number and hold it as a value for for example a new variable.

I apreciate every small hint, tip and help

If so far something isnt clear enough to you please just ask me to clarify

Kind regards,

Max

[Anonymous]

Thank you very much will I be able to enter that into my script or can I only use it as a formula ?

Kind regards

[Anonymous]

thank you very much, I will try it and give you Feedback

Kind regards

[niclaz79]

It works in both scripting and as expressions in your visualization.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/RangeFunctions/ra...

[Anonymous]

Thank you very much.

However, my script was not willing to execute Rangemin, no metter how I inserted the formula.

I have now solved the Problem by taking an extra step Prior to qlikview in Excel and it works perfectly fine now.

Thank you very much for your Help

best regards,

Max

[sunny_talwar]

You can make it simpler using RangeMin....

table:

LOAD *,

RangeMin(column1, column2, 0) as RangeMin;

LOAD * Inline [

column1,column2

300,45

-250,2000

-634,-4

];

[YoussefBelloum]

[Anonymous]

Yes I have heard that a few times now guys, thank you for your nice help´. However, the data I am using is way bigger and more complex than the sample data I gave you guys and I have to work with multiple Variables in my formula. I guess this was why the Rangemin wasnt working out for me, since Im no expert who can make it work no matter what.

However thank you very much guys,

Best regards

Max

[agomes1971]

Hi,

so now you can close this thread.

Thks

André Gomes