Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have the following Mekko Chart:
With the Dimensions:
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!!!
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
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
Thanks! It worked!
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>