Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

why the table overall total amount dis-appear when compute in eXP ?

Hi All

I have a Table , when i click on display in Org or S$ currency , the Table able to display summary total amount. The minute when user select the compute by eXP , the overall total amount disappear.

Any reasons why ?

Paul

1 Solution

Accepted Solutions

Re: why the table overall total amount dis-appear when compute in eXP ?

Check now

Capture.PNG

Money(Pick(

Match([Pls select 601st Dim],'rEVENUE','sales','cost','profit','eXP','nET_PROFIT','nET_PROFIT'),

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/$(Columndim89)/1000,

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000),

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}cost/$(Columndim89)/1000),

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}profit_amt/$(Columndim89)/1000),

Sum(Aggr(SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim101))),

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},nET_PROFIT={nET_PROFIT}>}Amount*1)/$(Columndim89)/1000,

Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount)/$(Columndim89)/1000),

$(vMoneyFormatK))

7 Replies
paulyeo11
Valued Contributor II

Re: why the table overall total amount dis-appear when compute in eXP ?

Enclosed my QV Doc

Re: why the table overall total amount dis-appear when compute in eXP ?

What is the expected total you would want to see?

paulyeo11
Valued Contributor II

Re: why the table overall total amount dis-appear when compute in eXP ?

Hi sunny

I expected to see 312.85 on 2016 and 338.85 on 2015.

summary total.png

Re: why the table overall total amount dis-appear when compute in eXP ?

Check now

Capture.PNG

Money(Pick(

Match([Pls select 601st Dim],'rEVENUE','sales','cost','profit','eXP','nET_PROFIT','nET_PROFIT'),

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/$(Columndim89)/1000,

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000),

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}cost/$(Columndim89)/1000),

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}profit_amt/$(Columndim89)/1000),

Sum(Aggr(SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim101))),

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},nET_PROFIT={nET_PROFIT}>}Amount*1)/$(Columndim89)/1000,

Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount)/$(Columndim89)/1000),

$(vMoneyFormatK))

paulyeo11
Valued Contributor II

Re: why the table overall total amount dis-appear when compute in eXP ?

Hi sunny

your mind very sharp.

Thank you

Paul

paulyeo11
Valued Contributor II

Re: why the table overall total amount dis-appear when compute in eXP ?

Hi Sunny

By the way , when combine all SOURCE data how come you know need to add Aggr ?

Paul

Re: why the table overall total amount dis-appear when compute in eXP ?

Whenever the issue is with total, it usually boils down to a need for Aggr() function.

Community Browser