Small help with chart

[#1]

Hello dear community,

I yet again need your help.

In the attachment I have a chart which is not working as it should be.

When I select the location, it still shows the data for the rest of the locations.

How can I solve this?

Picture 1 is what I get, and I need the layout in the second picture.

Thanks in advance

[ashfaq_haseeb]

Hi,

As QlikView is associated model.

What are you trying cannot be achieved.

May be you need to design new report or look at expression causing issue.

Regards

ASHFAQ

[#3]

I am sorry, but why is it not possible?

[maxgro]

try to disable this field in the chart

No. Recipients

[ashfaq_haseeb]

Because of Set analysis you use in expression No. Recipients

=count(DISTINCT {<Location=E({<Location={''}>})>}UserApp)

Remove this expression.

It will work as you want.

Regards

ASHFAQ

[#6]

That solves it, but why is that the issue? How can I replace that expression?

[aveeeeeee7en]

Hi

Your  No. Recipients Expression is causing Problem.

Replace your No. Recipients expression with:

=COUNT({$<Location -= {""}>}DISTINCT UserApp)

Your No. Recipients Expression is causing Problem:

=count(DISTINCT {<Location=E({<Location={''}>})>}UserApp)

Also, see the Attachment.

Regards

Aviral Nag

[ashfaq_haseeb · Accepted solution]

Hi use this expression

=count(DISTINCT {<Location-={''}>}UserApp)

Regards

ASHFAQ