Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
manojciti
Contributor III
Contributor III

Bar chart help with Aggr Function

HI All,

 

Need help in resolving issue of Bar Chart. 

 

I have  stacked bar chart with Dimension as Country and measure as 

Count({<[KPI ID]={"=$(PercentKPI)>=0.08"},[NUMBER FORMAT]={'Percentage'},[MONTH NUMBER]= {"$(vMaxMonth)"}>}Distinct [KPI ID])  AS RED

Count({<[KPI ID]={"=$(PercentKPI) < 0.08"},[NUMBER FORMAT]={'Percentage'},[MONTH NUMBER]= {"$(vMaxMonth)"}>}Distinct [KPI ID]) AS GREEN

 

where variable percetnKPI is SUM(Passed)/ Sum(Failed) 

 

BArchart show all values as same 2 for all bar for all country as I have only 2 KPI count and all for GREEN but what I want as breakup by Countries which comes after sleection 

 

manojciti_1-1648466767526.png

 

 

for eg:- in above chart  Luxemberg show default value as 2 for green but when click on it it shows 1 Amber and 1 Red and that's what I need as default value o bar

 

 

manojciti_0-1648466636816.png

 

 

 

Labels (1)
9 Replies
Joseph_Musekura
Support
Support

@manojciti,

 

Did you try to represent it as " stacked bar chart"?
Can you, at least, share your application?
/joseph

manojciti
Contributor III
Contributor III
Author

HI Joseph,

 

Its stacked bar chart only with 3 measures as GREEN,AMBER & RED .so in second image you can see when i click on country it giving me correct color as 1 for AMBER and 1 for RED  but when nothing selected its showing overall green instead of breakup by 3 Color(measure )  .

abhijith28
Creator II
Creator II

@manob 

Can you share the sample qliksense app with the data to work out

manojciti
Contributor III
Contributor III
Author

Attached Sample Data file

manojciti
Contributor III
Contributor III
Author

Attached as requested

abhijith28
Creator II
Creator II

@manojciti 

Variable returns single value. Instead use if condition for each measure

Ex: for Green

if(
(sum([NO. OF FAIELD])
/(sum([NO. OF FAIELD])
+sum([NO. OF PASSED])))<.05,

Count({<[NUMBER FORMAT]={'Percentage'},[MONTH NUMBER]= {'44621'} >}Distinct [KPI ID]),0)

 

manojciti
Contributor III
Contributor III
Author

HI Abhijith,

 

I tried but its not working as expected,

can you please update attached qliksense app and share .that will be helpful.

 

Regards

Manoj

abhijith28
Creator II
Creator II

Hi,

The count of KPI ID is not available for Amber and red. The data itself is not available

As a result you won't see stacked bar chart. 

Joseph_Musekura
Support
Support

Hi @manojciti,
Can you check https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Visualizations/Bar-C... for bar chart vs Stacked style? 

Normally, what you are doing should work but you need to check the data model. See for example this simple example using one dimension and 3 measures (similar to what you want to achieve)

https://community.qlik.com/t5/New-to-Qlik-Sense/100-Stacked-Bar-Chart-using-multiple-measures/td-p/1...

/joseph