topic Re: help for data lookup in QlikView

help for data lookup

Wed, 04 Sep 2013 12:29:42 GMT

Dear all,

I have a problem and can´t find a solution for it.

I want to select a reference and then see all clients under this reference but in the same time I want to see if one of this clients is duplicated. Duplicated in the sence of that the client is also part of another reference.

My questions: 1) How can I make it visible that this client is "duplicated"?
2) Is it possible that he also shows me in which references the client it also part of it?

Thanks for your help !!!

Regards

Martin

Re: help for data lookup

swuehl — Wed, 04 Sep 2013 12:47:03 GMT

You should be able to do this using implicite field value definitions in a set expression (i.e. using the p() function, while clearing the field you selected in). Something along these lines:

=count({<Client = p(), Reference= >} DISTINCT Reference)

e.g. in a chart with dimensions Client and Reference and selection done on Reference.

There are some examples in the forum on how to do this, search the forum or post a small sample app.

Re: help for data lookup

tresB — Wed, 04 Sep 2013 12:47:24 GMT

May be like this?

PFA

Re: help for data lookup

Gysbert_Wassenaar — Wed, 04 Sep 2013 12:50:43 GMT

See attached example. It shows the sales persons per region, a count of regions that the sales person is active in and the list of those regions. That sounds like what you're trying to do.

Or maybe this works for you too: QlikView App: The Power Of Yellow (Show Alternatives)

Re: help for data lookup

Wed, 04 Sep 2013 13:07:15 GMT

Thank you for you quick help... it was so easy ^^
I have tried so complicated things ...

THANKS TO BOTH