topic Re: Re: set analysis: use complete dataset and 1 selection in QlikView

set analysis: use complete dataset and 1 selection

Wed, 30 Jul 2014 07:49:04 GMT

I want to disregard all selections for this expression, except the city_id

The expression calculates the percentage of the population that has called the infocenter.

But the total population always has to be the total population, except when you select a city.

Then it has to be the total population of that city, not considering all the other selections that are made.

This is what I have, just disregarding all the selections:

count(DISTINCT inforequest_id)/count(total DISTINCT{1} inhabitant_id)

How do I add that the city_id has to be the selected city_id?

Hope someone can help!

Kind regards,

Katleen

Re: set analysis: use complete dataset and 1 selection

Anonymous — Wed, 30 Jul 2014 07:54:14 GMT

Hi,

Something like below,

count(DISTINCT inforequest_id)/If(GetSelectedCount(city_id)>0, count(total DISTINCT inhabitant_id), count(total DISTINCT{1} inhabitant_id))

Re: set analysis: use complete dataset and 1 selection

er_mohit — Wed, 30 Jul 2014 07:54:28 GMT

Try this

aggr((count(DISTINCT inforequest_id)/count(total DISTINCT{1} inhabitant_id)),city_id)

Re: set analysis: use complete dataset and 1 selection

Wed, 30 Jul 2014 08:08:20 GMT

Looks like it works, thanks!

Re: set analysis: use complete dataset and 1 selection

Wed, 30 Jul 2014 08:09:34 GMT

The issue that I have now is that when I select a month/quarter/.. the percentage goes over 100%

Re: set analysis: use complete dataset and 1 selection

Anonymous — Wed, 30 Jul 2014 08:30:47 GMT

Do you want month/quarter/.. selection to be ignored after city_id selection? If so, you may have to ignore them individually. Something like below,

count(DISTINCT inforequest_id)/count({$<month=, quarter=, ....>} DISTINCT total inhabitant_id)

Re: set analysis: use complete dataset and 1 selection

Wed, 30 Jul 2014 08:35:43 GMT

The original question is solved.

The issue that I have now is that when I select a month/quarter/.. the percentage goes over 100%

Re: set analysis: use complete dataset and 1 selection

Anonymous — Wed, 30 Jul 2014 08:43:23 GMT

Do you think you can provide your qvw with scrambled data. Without seeing application, it is difficult to understand the type of issue and give you correct resolution.

Re: Re: set analysis: use complete dataset and 1 selection

Wed, 30 Jul 2014 09:15:42 GMT

I added a sample qvw

Re: set analysis: use complete dataset and 1 selection

Anonymous — Wed, 30 Jul 2014 10:07:54 GMT

Logic seems to be okay. I have selected project MIWA and Quarter Q1 and found inforequest_id=188 and NULL inhabitant_unit=139 which is 135,25%.

If you want to ignore quarter and month selection, you may use below expression,

count(DISTINCT inforequest_id)/NullCount(total{<inforequestQuarter=, inforequestMonth=>} inhabitant_until)

Re: Re: set analysis: use complete dataset and 1 selection

Wed, 30 Jul 2014 10:16:59 GMT

Exactly what I wanted, thank you very much!