100% Stacked Bar for Count Unique Products

[vidyasagar159]

Hi All,

Hope you are doing great. Can some please help me in converting the below measure expression into 100% stacked bar.

Dimension1:

PLANYEAR (example: 2010,2011,2012,2013....2018)

Dimension2:

=

if(WildMatch(MORNINGSTARCATEGORY,'*Target*') and TRPFUNDINDICATOR=1,'Plans Using TRP RDFs',

if(WildMatch(MORNINGSTARCATEGORY,'*Target*') and TRPFUNDINDICATOR=0,'Plans Using NON TRP RDFs',

if(IsNull(MORNINGSTARCATEGORY) and TRPFUNDINDICATOR=0 ,'Empty Values',

'Plans Without RDFs'

)))

Measures Expression:

count(distinct PLANNAME)

With this expression, i am getting right count. But when I trying to convert this 100% I am not getting right results.

The expression I tired :

count(distinct PLANNAME) / count(distinct TOTAL <PLANYEAR> PLANNAME)

Result I am getting is

Thanks,

-Vidya

[OmarBenSalem]

This normally should work !

Can u share a test app please??

[vidyasagar159]

Unfortunately, I am working in Qlik Sense. Let me try to put up some data.

Thanks,

-Vidya