Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.