Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vidyasagar159
Contributor

100% Stacked Bar for Count Unique Products

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


100% Percentage Stacked for unique plans.PNG

Thanks,

-Vidya

2 Replies
OmarBenSalem
Esteemed Contributor

Re: 100% Stacked Bar for Count Unique Products

This normally should work !

Can u share a test app please??

vidyasagar159
Contributor

Re: 100% Stacked Bar for Count Unique Products

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

Thanks,

-Vidya

Community Browser