topic Re: Regarding Total Mode as a average in Straight Table in QlikView

Regarding Total Mode as a average in Straight Table

reema_dangwal — Wed, 23 Aug 2017 11:30:38 GMT

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.

Product	Sales	Percentage
	4100	11.8
ProductA	500	5
ProductB	600	10
ProductC	700	5
ProductD	800	20
ProductE	900	16
ProductF	100	17
ProductG	200	27
ProductH	300	18

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

Re: Regarding Total Mode as a average in Straight Table

sunny_talwar — Wed, 23 Aug 2017 11:33:57 GMT

How about you use this as expression

Avg(Percentage)

with Expression Total as total mode

Re: Regarding Total Mode as a average in Straight Table

Kushal_Chawda — Wed, 23 Aug 2017 11:38:52 GMT

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

=avg(Percentage)

Re: Regarding Total Mode as a average in Straight Table

reema_dangwal — Wed, 23 Aug 2017 11:57:52 GMT

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

Re: Regarding Total Mode as a average in Straight Table

sunny_talwar — Wed, 23 Aug 2017 12:03:24 GMT

May be try this

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

Still using expression total as total mode

Re: Regarding Total Mode as a average in Straight Table

reema_dangwal — Wed, 23 Aug 2017 12:23:15 GMT

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

Re: Regarding Total Mode as a average in Straight Table

sunny_talwar — Wed, 23 Aug 2017 12:25:52 GMT

That would be really helpful