Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reema_dangwal
Contributor
Contributor

Regarding Total Mode as a average in Straight Table

Hi All,

I need to create a dashboard and show sales and percentage as a expression in straight table. Now for totals, percentage has to be displayed as Total Mode = Average.

 

ProductSalesPercentage
410011.8
ProductA5005
ProductB60010
ProductC7005
ProductD80020
ProductE90016
ProductF10017
ProductG20027
ProductH30018

The total for percentage is displaying 11.8 as shown in the attached files(also above), however if we calculate manually, the percentage total(average) should be 118/8 = 14.75 but it is showing 11.8 since it is calculating it as 118/10(including products for which expression is null).

Please suggest how correct average can be displayed.

Thanks,

Reema

6 Replies
sunny_talwar

How about you use this as expression

Avg(Percentage)

with Expression Total as total mode

Capture.PNG

Kushal_Chawda

Use total mode as "Expression total" and use below expression

=avg(Percentage)

reema_dangwal
Contributor
Contributor
Author

This is actually a dummy data, in actual we need to do sum for expression (Sum(A)/Sum(B) as percentage), is it possible without using the average function in expression?

Thanks

sunny_talwar

May be try this

Avg(Aggr(Sum(A)/Sum(B), Product))

Still using expression total as total mode

reema_dangwal
Contributor
Contributor
Author

Even this is not working, I will try to create the replica of expression and upload the file for clarity.

sunny_talwar

That would be really helpful