Discussion board where members can get started with QlikView.
Seems like what you really need is a FirstSortedValue() function instead of set analysis....
I've never used that function. Can you assist me with its syntax? Tried
FirstSortedValue(AFPO.AUFNR, AFPO.STRMP, 1) as NewestOrder,
Where AFPO.AUFNR is the Production order number. but it errors out.
You need to do this in the script?
I dont need to I thought that was where the function was usually implemented per the examples I saw.
Can be implemented on the front end as well. firstsortedvalue
I don't think I can give you the exact expression without testing it out based on your dimension and expectation, but feel free to try it out.
Appears this may be working. Have to have a coworker verify in the system.
FirstSortedValue((AFPO.WEWRT/AFPO.PSMNG), -AFPO.STRMP, 1)