Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Thabang231
Contributor III
Contributor III

100 % stacked graph

Hi All 

 

I am experiencing issues here, I wanna create a 100% stacked bar graph for the below graph but i seem not to win.

Thabang231_0-1666257156971.png

My dimension is : =If (Match([Group-Name],'Non-Perishables','Perishables','Freight and Warehousing') , [Group-Name])

 

 

my 1st measure is : COUNT(distinct if([Status] = 'In Service' AND [Binary] ='0',[Vehicle])) 

my 2nd measure is COUNT(distinct if([Status] = 'Out Of Service' AND [Binary] ='1',[Vehicle])) 

But my stacked cant do the 100% stacked please assist. Thank you in advance.

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

Measure1:

COUNT({<[Status] = {'In Service'}, [Binary] ={'0'}  >} distinct [Vehicle]) / COUNT( distinct [Vehicle])

Measure2:

COUNT({<[Status] = {Out Of Service'}, [Binary] ={'1'}  >} distinct [Vehicle]) / COUNT( distinct [Vehicle])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.