topic Re: Exclude extra selections / relationships when selecting from listbox in QlikView

Exclude extra selections / relationships when selecting from listbox

rajkapoor1 — Sat, 16 Nov 2024 03:36:04 GMT

Hi QV community,

I am trying to calculate the email count where A is a sender and receiver.

However, due to the relationship A has with B,C & D, it is also picking up the email count for B-C and D-C.

Ideally, if I am selecting A from a listbox I would like to obtain the email count for only A (email count = 10).

Is there a way I can exclude the extra count whereby A is not part of the equation i.e. exclude email count for B-C and D-C?

Looking forward to your replies.

Many thanks,

RK.

Re: Exclude extra selections / relationships when selecting from listbox

Anil_Babu_Samineni — Mon, 13 May 2019 13:25:05 GMT

May be this?

Count(TOTAL {<Sender={'A'}>} [Sender Address])+Count(TOTAL {<Receiver={'A'}>} [Receiver Address])

Re: Exclude extra selections / relationships when selecting from listbox

rajkapoor1 — Mon, 13 May 2019 13:39:41 GMT

Hi,

Thanks for your reply.

This would only work when A is selected. I am looking for something more dynamic. The email count should be able to vary depending on my selections i.e. if I chose B, it should give me email counts only related to B being a sender and a receiver.

Many thanks,

Re: Exclude extra selections / relationships when selecting from listbox

Anil_Babu_Samineni — Mon, 13 May 2019 13:45:06 GMT

On which field, you do filter? Can you club sender and receiver both into single field and use?

Re: Exclude extra selections / relationships when selecting from listbox

rajkapoor1 — Mon, 13 May 2019 15:07:06 GMT

I have created a listbox with all sender and receivers as follows:

Mailbox (receiver/sender)

If I select 'A', I want to see the volume count to be related to only A. In the example I've given below, the count should be 10. Please note that the volume should include both sent and received.

Thanks.