topic Nested FunctionCall in Set Analysis not working in QlikView

Nested FunctionCall in Set Analysis not working

Tue, 12 Oct 2010 00:55:46 GMT

Hi, I have a column the following structure:

MasterContactID	ContactID	Index	Description
90	90	1
90	90	2
90	90	3
90	90	4	Outbound
90	90	5	Outbound
90	90	6	Inbound
90	90	7	Inbound
90	91	1
90	91	2	Inbound
90	91	3	Outbound
90	91	4	Outbound
90	91	5	Outbound

What I am trying to get is:

"The 1st non-empty Description, for the smallest ContactID of the current MasterContactID"

So this record would be :

Outbound

I am trying to get this done with this Set analysis:

FirstSortedValue( {$<
ContactID = {"=Min(ContactID )"},
Description-={""}
>} distinct Description, ContactID )

But is not working, it is not filtering ContactID with ContactID = {"=Min(ContactID )"}.

Any Suggestions?

Thanks in advance four your time.

-Ed

Nested FunctionCall in Set Analysis not working

Anonymous — Tue, 12 Oct 2010 01:07:24 GMT

Ed, try
ContactID ={"$(=Min(ContactID))"}

Edit:
Nope, I'm wrong, you have to get min within master contact id, which is probably closer to this:
min(total<MasterContactID> ContactID)

Nested FunctionCall in Set Analysis not working

johnw — Tue, 12 Oct 2010 01:11:12 GMT

A few minor changes seem to fix it if I've understood the question:

firstsortedvalue({<ContactID={'$(=min(ContactID))'},Description-={''}>} Description, Index)

Edit: Following up for the same reason as Michael, I've assumed you are selecting or otherwise in the context of a specific MasterContactID. That's why there's no inclusion of it above. I don't know if this is the case.

Nested FunctionCall in Set Analysis not working

Tue, 12 Oct 2010 17:25:52 GMT

Thank you very much, the function did work, it seems i was calling the inner Min() wrongly.

Regards

EDIT: By the way, you assumption was correct I was selecting a MasterContactID. 🙂