Wrong Percentage values

[soha1902]

Hi All,

I am using one stacked bar chart in my dashboard. In this chart I am using two dimension and one expression.

This chart shows values more than 100%. Please see below screenshot

This calculation is wrong.It should not be more than 100%. I am using below expression

Sum(HOURS)

/

(

(

sum({<FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time={" Time:9 AM - 7 PM"}>} total <$(=GetCurrentField(Xaxis))> aggr(Count({<FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time={" Time:9 AM - 7 PM"}>} Distinct Date), KEY, Week))

*

Count({<FlgValue=,Project=, OName=,OMode=,Site=,GName=,Time={" Time:9 AM - 7 PM"}>} Distinct total <Week> Hour)

)

+

(

sum({<FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time-={" Time:9 AM - 7 PM"}>} total <$(=GetCurrentField(Xaxis))> aggr(Count({<FlgValue=, GName=,OMode=,OName=,Site=,Project=,Time-={" Time:9 AM - 7 PM"}>} Distinct Date), KEY, Week))

*

Count({<FlgValue=,Project=, OName=,OMode=,Site=,GName=,Time-={" Time:9 AM - 7 PM"}>} Distinct total <Week> Hour)

)

)

)

Please help me to solve this.

Thanks.

[qlikviewwizard]

Hi soha1902,

Can you attach the sample data with the file.

[soha1902]

Any Suggestions???

[mrossoit]

Upload your qvw, please. It will be easier to undestand your problem and help you.

Regards

MR