topic Re: Pivot filter based on the lowest number in QlikView

Pivot filter based on the lowest number

lorenzo_gibbo — Thu, 25 Aug 2011 17:06:10 GMT

Load from a database a data table like this:

I need to display in a pivot only the Code corresponding at the lowest number of sequence, as in the example below:

Do you have any suggestions for a formula set in the pivot which allows me to filter the data in this way?

Thanks all.

Fri, 26 Aug 2011 10:08:07 GMT

Hi Lorenzo - Try the attached

Loaded Table then laoded Min(Seq) in a resident load then in table only displayed those where seq=min (seq)

Fri, 26 Aug 2011 11:20:48 GMT

Hi,

Check the attached file.

HTH

its_anandrjs — Fri, 26 Aug 2011 11:39:33 GMT

Hi.

See the attached sample for clearity of your solution.

Regards,

Anand

lorenzo_gibbo — Fri, 26 Aug 2011 11:46:06 GMT

Thanks All!

Bye