topic Re: Small help with chart in QlikView

Small help with chart

Thu, 04 Sep 2014 11:37:17 GMT

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

Re: Small help with chart

ashfaq_haseeb — Thu, 04 Sep 2014 11:46:53 GMT

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

Re: Small help with chart

Thu, 04 Sep 2014 11:51:01 GMT

I am sorry, but why is it not possible?

Re: Small help with chart

maxgro — Thu, 04 Sep 2014 11:51:49 GMT

try to disable this field in the chart

No. Recipients

Re: Small help with chart

ashfaq_haseeb — Thu, 04 Sep 2014 11:53:46 GMT

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

Re: Small help with chart

Thu, 04 Sep 2014 11:56:38 GMT

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

Re: Small help with chart

aveeeeeee7en — Thu, 04 Sep 2014 11:58:42 GMT

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

Re: Small help with chart

ashfaq_haseeb — Thu, 04 Sep 2014 12:00:17 GMT

Hi use this expression

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

Regards

ASHFAQ