Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Re: Set Analysis Help Needed

Seems like what you really need is a FirstSortedValue() function instead of set analysis.... 

Highlighted
Contributor III
Contributor III

Re: Set Analysis Help Needed

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. 

Highlighted

Re: Set Analysis Help Needed

You need to do this in the script?

Highlighted
Contributor III
Contributor III

Re: Set Analysis Help Needed

I dont need to I thought that was where the function was usually implemented per the examples I saw. 

Re: Set Analysis Help Needed

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.

Highlighted
Contributor III
Contributor III

Re: Set Analysis Help Needed

Appears this may be working. Have to have a coworker verify in the system.

FirstSortedValue((AFPO.WEWRT/AFPO.PSMNG), -AFPO.STRMP, 1)