Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

100% stacked bar chart

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)

Tags (2)
2 Replies
MVP & Luminary
MVP & Luminary

Re: 100% stacked bar chart

Try:

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

/

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


talk is cheap, supply exceeds demand
Not applicable

Re: 100% stacked bar chart

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