topic Set Analysis Dimension=Dimension in QlikView

Set Analysis Dimension=Dimension

Fri, 23 Jul 2010 15:51:13 GMT

How would i convert this to a set anlysis?

if(Receipt_Store = Return_Store, min(Receipts.DATE))

Fri, 23 Jul 2010 16:23:47 GMT

min( {$<Receipt_Store = {'Return_Store'} >} Receipts.DATE )

jonathandienst — Fri, 23 Jul 2010 16:29:00 GMT

Assuming that you are looking for the minimum Receipts.DATE when the Receipt_Store is the same as the Return_Store:

If type: Min(If(Receipt_Store = Return_Store, Receipts.DATE))

Set Anal: Min({<Receipt_Store=Return_Store>} Receipts.DATE)

Jonathan

Fri, 23 Jul 2010 16:35:22 GMT

not sure why, but this returns null (-).

jonathandienst — Fri, 23 Jul 2010 16:38:45 GMT

To clarify

Min({<Receipt_Store=Return_Store>} Receipts.DATE)

Matches the value of field Receipt_Store with the value of field Return_Store

Min({<Receipt_Store={'Return_Store'}>} Receipts.DATE)

Matches the value of field Receipt_Store with the literal text 'Return_Store'.

Jonathan