topic Re: 100% stacked bar chart in QlikView

100% stacked bar chart

Wed, 11 Mar 2015 16:57:26 GMT

I can't figure out how to use the TOTAL function with this formula to give a 100% stacked bar chart

COUNT(DISTINCT {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)

I have a primary time-based dimension called 'Week' and a secondary dimension called 'Type'.

I tried the following formula but it didn't seem to work

COUNT(DISTINCT {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)

COUNT(DISTINCT TOTAL {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)

Gysbert_Wassenaar — Wed, 11 Mar 2015 16:58:54 GMT

Try:

COUNT(DISTINCT {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)

COUNT(DISTINCT TOTAL <Type> {$<UserName-={'*test*','loadbalance*'},TestAccount={'false'}}>}UserName)

Wed, 11 Mar 2015 17:08:16 GMT

Strange, the percentages seem to be adding up to over 100%