Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Regarding Total Mode as a average in Straight Table

How about you use this as expression

Avg(Percentage)

with Expression Total as total mode

Capture.PNG

Highlighted
MVP
MVP

Re: Regarding Total Mode as a average in Straight Table

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

=avg(Percentage)

Highlighted
Contributor
Contributor

Re: Regarding Total Mode as a average in Straight Table

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

Highlighted

Re: Regarding Total Mode as a average in Straight Table

May be try this

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

Still using expression total as total mode

Highlighted
Contributor
Contributor

Re: Regarding Total Mode as a average in Straight Table

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

Highlighted

Re: Regarding Total Mode as a average in Straight Table

That would be really helpful