topic Re: Cummulative Expression in QlikView

Cummulative Expression

suvechha_b — Thu, 09 Jul 2015 18:10:55 GMT

Hi ,

How to build the following chart :

Please find the attachement sample

In the sample model . I am using vPerFormula and vPerFormulaBud to calculate the sales and budget resp.

suvechha_b — Thu, 09 Jul 2015 18:50:03 GMT

where Sales is calculated with the help of variable , eg , vSales

vSales = sum({$<TranType = {'Sales_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

vBudget = sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Can anyone tell me how to write the following expression :

LOAD Sum(Budget)/Count(Budget) as Budget1

as vBudget / count(vBudget ) is also not working

and

Method 2 is RangeSum(Above()) Method:

=RangeSum(Above(vSales ), 0, RowNo()))

=RangeSum(Above(vBudget), 0, RowNo())) are not working

sunny_talwar — Thu, 09 Jul 2015 18:53:31 GMT

Wow! this is huge file. Were you not able to reduce the application size for uploading purposes?

maxgro — Thu, 09 Jul 2015 19:03:40 GMT

The file is too big.

What if every question has an attachment of some hundred megabytes?

suvechha_b — Thu, 09 Jul 2015 19:11:00 GMT

Sales Value is calculated a variable :

vPerFormula : sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Budget Value is calculated a variable :

vPerFormulaBud : sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

How to use this variables in the cummulative sum .

as Sum(Budget)/Count(Budget) as Budget1

and

Method 2 is RangeSum(Above()) Method:

=RangeSum(Above(Sum(Budget1), 0, RowNo()))

=RangeSum(Above(Sum(Sales), 0, RowNo()))

Re: need to get the cummulative sum