Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vicobi123
Contributor III
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
Specialist II
Specialist II

Can you share some sample data.

MarcoWedel

please post a sample application showing this behaviour.