topic Re: Total qualifier in QlikView

Total qualifier

Tue, 25 Mar 2014 05:04:16 GMT

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

Re: Total qualifier

sushil353 — Tue, 25 Mar 2014 05:24:08 GMT

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

Re: Total qualifier

Tue, 25 Mar 2014 05:42:04 GMT

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

Re: Total qualifier

sushil353 — Tue, 25 Mar 2014 05:46:43 GMT

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

Re: Total qualifier

its_anandrjs — Tue, 25 Mar 2014 05:47:04 GMT

Hi,

Write like this

=sum( TOTAL SalesValue)

Hope this helps

Thanks & Regards

Re: Total qualifier

jagan — Tue, 25 Mar 2014 05:54:21 GMT

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.

Re: Total qualifier

Fri, 28 Mar 2014 07:13:31 GMT

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)

Re: Total qualifier

Wed, 11 Feb 2015 07:01:23 GMT

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