topic Re: Bar chart help with Aggr Function in App Development

Bar chart help with Aggr Function

manojciti — Mon, 28 Mar 2022 11:26:36 GMT

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

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

Re: Bar chart help with Aggr Function

Joseph_Musekura — Mon, 28 Mar 2022 12:26:38 GMT

@manojciti,

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

Re: Bar chart help with Aggr Function

manojciti — Mon, 28 Mar 2022 12:30:14 GMT

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 ) .

Re: Bar chart help with Aggr Function

abhijith28 — Mon, 28 Mar 2022 13:09:26 GMT

@manob

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

Re: Bar chart help with Aggr Function

manojciti — Mon, 28 Mar 2022 15:18:49 GMT

Attached Sample Data file

Re: Bar chart help with Aggr Function

manojciti — Mon, 28 Mar 2022 15:19:11 GMT

Attached as requested

Re: Bar chart help with Aggr Function

abhijith28 — Tue, 29 Mar 2022 08:08:43 GMT

@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)

Re: Bar chart help with Aggr Function

manojciti — Tue, 29 Mar 2022 08:20:38 GMT

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

Re: Bar chart help with Aggr Function

abhijith28 — Tue, 29 Mar 2022 08:56:30 GMT

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.

Re: Bar chart help with Aggr Function

Joseph_Musekura — Fri, 01 Apr 2022 07:26:29 GMT

Hi @manojciti,
Can you check https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Visualizations/Bar-Chart/bar-chart.htm 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/1739658

/joseph