Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Small help with chart

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

1 Solution

Accepted Solutions
ashfaq_haseeb

Hi use this expression

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

Regards

ASHFAQ

View solution in original post

7 Replies
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

Not applicable
Author

I am sorry, but why is it not possible?

maxgro
MVP
MVP

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

Not applicable
Author

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

aveeeeeee7en
Specialist III
Specialist III

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

Hi use this expression

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

Regards

ASHFAQ

View solution in original post