Show Value in Chart Respect the Total %

[#1]

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

[#2 · Accepted solution]

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

[#3]

Thanks! It worked!

[#4]

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>