Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This normally should work !
Can u share a test app please??
Unfortunately, I am working in Qlik Sense. Let me try to put up some data.
Thanks,
-Vidya