Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
plkinnera
Partner
Partner

Display selected name as name and non selected possible values as other in qliksense bar chart

Hi,

My business user's are asking to display the data as shown below. So please suggest me to achieve this requirement.

Example Table:

Area_1Area_2Area_3Sales
DermaHSA10
DermaHSAA20
DermaHSAB30
DermaASB40
DermaASBA50
DermaASBB60
DermaINC10
DermaINCA20
DermaINCB30
DermaRSD40

 

If user selected Area_1='Derma' and Area_2='HS','AS', then the stacked bar chart should display non selected values in Area_2(IN,RS) as 'Other' along with selected Area_2 values as HS ,AS.

legends for stack should be HS,AS,Other

Dimension=Month_Year

Stack=Area_2

Expression=Sum(Sales)

 

 

1 Reply
stevejoyce
Creator III
Creator III

I believe this should work...

Your expression in your chart should ignore the Area_2 field selection:  Sum({<Area_2> } Sales).  

On your Area_2 dimension, choose Limitation = Fixed number, and use an expression Count(Distinct Area_2) + 1.

 

Alternatively it can be done with a calculated dimension, but the above would be nicer to implement if it gets what you want.