topic Quick Set Analysis Question in QlikView

Quick Set Analysis Question

Mon, 19 Apr 2010 23:43:17 GMT

Greetings,

I was wondering if anyone could help me out with a set analysis problem. I have two fields: SalesDate and Receiver. Both are selectable via multibox. I would like to present the Max(SalesDate) in a separate text box based on current Receiver.

Currently I have:

=Max( {$ <Receiver>} SalesDate )

This works fine until I change the SalesDate to something in the past. I'm sure this is a simple solution, I just need to be steered in the right direction. Any help would be appreciated. Thanks in advance.

Quick Set Analysis Question

Oleg_Troyansky — Tue, 20 Apr 2010 00:19:15 GMT

I don't think you need Set Analysis at all... Using basic QlikView functionality, the expression max(SalesDate) will return the max available SalesDate. If a specific Receiver is selected, the furmula will return the max Date associated with that specific Reciever.

Quick Set Analysis Question

Tue, 20 Apr 2010 00:40:54 GMT

Thanks Oleg.

I'm still running into a problem when I change the SalesDate in the multibox though. If the max SalesDate is 1/31/2010 and I select the SalesDate 1/28/2010 in the multibox, then the max(SalesDate) function returns 1/28/2010.

I would like the returning value in the text box to be the max of the entire SalesDate set belonging to the selected Receiver, regardless of a change in date in the multibox.

Quick Set Analysis Question

Tue, 20 Apr 2010 06:22:13 GMT

Would a screen shot help anyone?

Quick Set Analysis Question

nicole — Tue, 20 Apr 2010 07:20:51 GMT

Maybe this:

Max({$<SalesDate=>} SalesDate)

Quick Set Analysis Question

Tue, 20 Apr 2010 07:37:10 GMT

How about this:

=max( {<SalesDate=>} SalesDate)

This would ignore any made selections for SalesDate

Quick Set Analysis Question

Tue, 20 Apr 2010 07:40:07 GMT

Thank you! Works perfectly.