Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today

Average Sales

Creator II
Creator II

Average Sales

Using Average from a Resident Load Statement

Using Average of Total Sales

Using Average of Total Sales and Set Analysis

Labels (1)
Attachments
Comments
Luminary
Luminary

Why not just use

avg(Total Sales)

?

0 Likes
Creator II
Creator II

If you make a selection, it will Total all the relative Sales, not All the sales.

In some scenarios, it may work.

0 Likes
Luminary
Luminary

You can disregard any selections by using set analysis.

avg({1} Total Sales)

It seems a bit drastic to reload all the data just to get this number when it could be millions of rows

Cheers

0 Likes
Creator II
Creator II

Hi Richard,

I have updated the file to allow those other options as they can all be used, dependent on the scenario.

Cheers

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-01-05 10:32 PM
Updated by: