Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi can any body give simple example and general usage of total qualifier
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.
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
i have personal edition iam unable to see qvw can you please give me atleast one expression
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
Hi,
Write like this
=sum( TOTAL SalesValue)
Hope this helps
Thanks & Regards
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.
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)
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