Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vicobi123
New Contributor III

100% stacked bar chart

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

2 Replies
neelamsaroha157
Valued Contributor II

Re: 100% stacked bar chart

Can you share some sample data.

Re: 100% stacked bar chart

please post a sample application showing this behaviour.