topic Interesting chart problem in QlikView

Interesting chart problem

Mon, 18 Jul 2011 16:25:08 GMT

I have Regions that have multiple Countries. I also have applications that are used by multiple counties across regions.

I need a chart that will show per Application what is the percent of countries using it in each region.

For Instance APP 1 is used in 10% of countries in Region 1,

25% in countries for Region 2 and so on

Interesting chart problem

Mon, 18 Jul 2011 19:44:49 GMT

write an expression 1- (SUM(Total Application)/ Count(Region))

if I understood your problem correctly.

Re: Interesting chart problem

swuehl — Mon, 18 Jul 2011 20:10:04 GMT

If your 1. dimension is App and second Region, I think it could be something like

count ( distinct Country) / count (distinct total <Region> Country)

see also attached sample for discussion.

Regards,

Stefan

Interesting chart problem

Mon, 18 Jul 2011 22:26:40 GMT

It looks like it is correct when you open your example. For App1 in Europe distribution is 75% which is correct. However if you click on App1 for instance the chart becomes 100% for each region which is not correct.

Can not figure out the problem.

Also in your code what is <Region>syntax mean? . the syntacs os a set analysis however you do not have {}

Re: Interesting chart problem

swuehl — Mon, 18 Jul 2011 22:51:24 GMT

Hi,

it is correct regarding the current selection, but of course incorrect regarding your requirement.

you need to add a {1} to disregard the current selection:

=count ( distinct Country) / count ({1} distinct total <Region> Country)

the syntax means:

per App and region

count associated distinct Countries and devide by the total number of countries in that region.

If we use count( distinct total Country), we would disregard the charts dimension App and region, with count( distinct total <Region> Country), we disregard App Dimension, but not Region dimension.

Syntax looks like set analysis because of <>, but just indicates the fields (please have a look at the count function in manual for more details).

Hope this helps,

Stefan

Nachricht geändert durch swuehl

Re: Interesting chart problem

Tue, 19 Jul 2011 15:11:02 GMT

Thanks a lot