Discussion Board for collaboration related to QlikView App Development.
I have an ordertable that contains original orders (-00) and subsequent suborders (-XX), something like this:
I want to render the following only loading the maximum of the suborders where exists or the orginalorder where suborderdoesn't exist, with the resulting table:
In fact lower numbered suborders are not of interest loading.
How do I go about solving this (scripting this), to render the table with only the highest order suffix ?
Thank you & BR,
Go to Solution.
LOAD FirstsortedValue(Test,-subfield(Test,'-',2)) as Test
Group by subfield(Test,'-',1)
Or in the first case, use something like this:
LOAD FirstsortedValue(Test,-right(Test,2)) as Test
Group by left(Test,5)