compare FIELDS WITH CONDITION

[entsh]

ID	NUM1	NUM2	NUM3
1	4		4 (between 4 and null=4)
2	3		3 (between 3 and null=3)
3	3	5	5 (between 3 and 5 ,max=5)
4	7	6	7(between 7 and 6 ,max=7)
5		7	7 (between 7 and null=7)
6			(between null and null =null

HELLO

please see the table

i want an expression (edit script window) for NUM3

result

id	num3
1	4
2	3
3	5
4	7
5	7
6

thx

[anat · Accepted solution]

you can try using "nummax" or "rangemax" functions to get max values from 2 fields.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ra....

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ra...