100% stacked bar chart

vicobi123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All, i'm struggling to create a 100% stacked bar chart. I have a stacked chart but it doesn't add up to 100%. Please i need help.

My dimension is: If(WildMatch(Product,'Gold','Silver','Bronze'), Product,Null())

and my measure is:

sum(

Product={'Gold','Silver','Bronze'},

HousePK=P({1<Product={'Remote'}>}HousePK)>}

HouseCount)

sum(total<HousePK>

< Product={'Gold','Silver','Bronze'},

HousePK=P({1<Product={'Remote','Featured Employer','Featured House','Man of the Week','Sponsored House','Spotlight Ad','Spotlight','Mobile '}>}HousePK)

}

HouseCount)

the above set analysis is just one of the measures against all the product listed and it's adding up to 150% and that's not what i'm looking for.

I want to create a stacked bar chart where it's showing a subset of all the records in the Product field (Product={'Remote','Featured Employer','Featured House','Man of the Week','Sponsored House','Spotlight Ad','Spotlight','Mobile '}) to reach the total of 100%. I hope i'm making sense

Re: 100% stacked bar chart

neelamsaroha157 — Fri, 14 Sep 2018 19:50:19 GMT

Can you share some sample data.

Re: 100% stacked bar chart

MarcoWedel — Fri, 14 Sep 2018 20:03:30 GMT

please post a sample application showing this behaviour.

topic Re: 100% stacked bar chart in QlikView

100% stacked bar chart

Re: 100% stacked bar chart

Re: 100% stacked bar chart