Qlik sense bar chart is showing 100 percentage

[ranjitalenka]

Hi ,

My bar chart in qlik sense is giving 100 percent instead of giving correct values

The code is giving correct value for KPI.

My code:

Count({<[SLA Met]= {'SLA Met'},[#Call Month]=>}number)/Count({<[SLA Met]={'SLA Met','Not Met'}, [#Call Month]=>}number)

[abhijitnalekar]

Hi @ranjitalenka,

Please modify your expression as below.

Count({<[SLA Met]= {'SLA Met'},[#Call Month]=>}number)/

Count({<[SLA Met]={'SLA Met','Not Met'}, [#Call Month]=>} Total number) 

[ranjitalenka]

Thanks a lot for your reply, I tried the same, Still bar chart is showing 100%.

[vinieme12]

Check the count of "SLA MET" and "SLA NOT MET" do you have values for both? your "SLA NOT MET" might be 0

also are you using any dimension in your chart or just with a measure? make sure to use a dimension that has an appropriate relation to the metric

[ranjitalenka]

Hello,

I have values for both "SLA MET" and "SLA NOT MET",I am using just a measure, how to use dimension?

Thanks in advance.

[vinieme12]

try a table with Dimension = [SLA MET]

Expression1

Count({<[SLA Met]={'SLA Met','Not Met'}, [#Call Month]=>}number)

and expression 2

Count({<[SLA Met]={'SLA Met','Not Met'}, [#Call Month]=>}number)

/

Count({<[SLA Met]={'SLA Met','Not Met'}, [#Call Month]=>}TOTAL number)