Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Total qualifier

Hi can any body give simple example and general usage of total qualifier

1 Solution

Accepted Solutions
Luminary Alumni

Hi,

Suppose you have the following data

Year, Sales

2013, 200

2012, 100

Suppose if you use Year as Dimension and

If you use Sum(Sales) in expression then for

2013 - Sales = 200

2012 - Sales = 100

If you use Sum(TOTAL Sales) in expression then for

2013 - Sales = 300

2012 - Sales = 300

If you use TOTAL it ignores the expression, so in every row you will get the overall total.

Regards,

Jagan.

7 Replies
Master II

Hi,

TOTAL is a useful qualifier that can be added to an aggregation function (such as Sum, Count, and Avg) to tell QlikView to ignore the dimensions of a chart in the calculation. By default, it ignores all the dimensions, but we can be more specific and tell it to ignore some while respecting others.

Find attached example.

HTh

Sushil

Not applicable
Author

i have personal edition iam unable to see qvw can you please give me atleast one expression

Master II

Hi,

Data Set Used:

Table:

[

Year,Month,Sales

2012,Jan,1

2012,Feb,2

2012,Mar,3

2012,Apr,4

2012,May,5

2012,Jun,6

2012,Jul,7

2012,Aug,8

2012,Sep,9

2012,Oct,10

2012,Nov,11

2012,Dec,12

2013,Jan,13

2013,Feb,14

2013,Mar,15

2013,Apr,16

2013,May,17

2013,Jun,18

2013,Jul,19

2013,Aug,20

2013,Sep,21

2013,Oct,22

2013,Nov,23

2013,Dec,24

2014,Jan,25

2014,Feb,26

2014,Mar,27

2014,Apr,28

2014,May,29

2014,Jun,30

2014,Jul,31

];

Create a Pivot table:

2. Month

Then Expressions:

1. Sum(Sales)

2. sum( TOTAL Sales)

3. sum( TOTAL <Year> Sales)

HTH

Sushil

MVP

Hi,

Write like this

=sum( TOTAL SalesValue)

Hope this helps

Thanks & Regards

Luminary Alumni

Hi,

Suppose you have the following data

Year, Sales

2013, 200

2012, 100

Suppose if you use Year as Dimension and

If you use Sum(Sales) in expression then for

2013 - Sales = 200

2012 - Sales = 100

If you use Sum(TOTAL Sales) in expression then for

2013 - Sales = 300

2012 - Sales = 300

If you use TOTAL it ignores the expression, so in every row you will get the overall total.

Regards,

Jagan.

Not applicable
Author

HI Jagan,

Thats Fine..

I have one requirement in the same way

I have 5 Products.

My Concern is (1 Product / 5 Products) is common for any selection..

I will Select only Products..

Sum(Sales) is Fine.

In Sum(Total Sales), If I select a Year then I want to get Total for a Particular Year but no need of all months.

If I select a Month then I want to get Total for a Particular Month but no need of all months.

Expr: =sum(RollingAvg)/sum(TOTAL{<ABPM_DM_MarketProductGroups>} RollingAvg)

Not applicable
Author

Hi, can u plz help us on this,the actual expression is

=AGGR(NUM(RANK(SUM({<R6={'C'},[Organization Name]=,[Organization ID]=,[Organization Name|ID]=,[Sold To Opt Out Flag]={'N'}>}[Monthly Sales]), 4, 1)),[Organization Name|ID])

the above is the script i am trying to do in script editor

Community Browser