Total qualifier

[#1]

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

[sushil353]

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

[#3]

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

[sushil353]

Hi,

Data Set Used:

Table:

LOAD * Inline

[

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:

add dimensions: 1. Year

2. Month

Then Expressions:

1. Sum(Sales)

2. sum( TOTAL Sales)

3. sum( TOTAL <Year> Sales)

HTH

Sushil

[its_anandrjs]

Hi,

Write like this

=sum( TOTAL SalesValue)

Hope this helps

Thanks & Regards

[jagan · Accepted solution]

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]

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)

[#8]

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