topic Re: Show Value in Chart Respect the Total % in QlikView

Show Value in Chart Respect the Total %

Wed, 04 Jun 2014 20:53:29 GMT

Hello!

I have the following Mekko Chart:

With the Dimensions:

Zone (Values: Zone 1 / Zone 2 / Zone 3 / Zone 4)
Anomaly (Values: With Anomaly / No Anomaly)

And the Expression:

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)') =$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

(Where I show the Expression as the Relative %)

But what I want is to show the 100% for every Zone. Because I have:

Zone 1: 13,39% + 3,13% = 16,42%

Zone 2: 18,47% + 4,22% = 22,69%

And so on...

I would like to show something like:

Zone 1: 81,57% + 18,43% = 100%

Zone 2: 81,40% + 18,60% = 100%

And so on...

Do you know how could I do this?

Thank you!!!

Re: Show Value in Chart Respect the Total %

Wed, 04 Jun 2014 21:24:32 GMT

try maybe:

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)') =$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID) /COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)') =$(='$(vDateTo)')"}>} DISTINCT TOTAL <Zone> ACCOUNT_ID)

and turn off relative

Re: Show Value in Chart Respect the Total %

Thu, 05 Jun 2014 04:00:16 GMT

Thanks! It worked!

Re: Show Value in Chart Respect the Total %

Thu, 05 Jun 2014 06:37:52 GMT

05-06-2014 06:00 użytkownik "mart pabst" <qcwebmaster@qlik.com> napisał:

Qlik Community <http://community.qlik.com/> Show Value in Chart
Respect the Total %
reply from mart pabst
<http://community.qlik.com/people/mpabster?et=watches.email.thread> in *New
to QlikView* - View the full discussion
<http://community.qlik.com/message/542185?et=watches.email.thread#542185>