This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have the following database:
how do i get the minimum and the second minimum + duration in this format:
Thanks a lot,
You can use set analysis within forstsortedvalue() for the same. PFA
View solution in original post
Please refer the attached.
This might not work for multiple Product IDs. In such cases, you might have to use FirstSortedValue() like in attached.
FirstSortedValue(DISTINCT Aggr(Sum(Duration),[Product ID], [Sale Price]), [Sale Price],2)
ok, great, but i have one more question:
can i combine firstsortedvalue with a condition?
let's say, the first and second minimum only after 11 aug.
and the results will be 20 with Duration 1 and 30 with Duration 4.