Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

WHY CHART 2 ONLY WRONG FOR nET_PROFIT ?

Hi All

I have a very funny encounter. when click on step 1 dimension = nET_PROFIT , Below expression use by chart 2 is wrong :-

Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim601) ={$(ColumnDim601)}>} Amount*-1/ $(Columndim89)/1000),

After i change the expression to below , it work fine , see Chart 1:-

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

Now when Click on Step 2. for rEVENUE , my chart 2 expression as below  :-

Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim601) ={$(ColumnDim601)}>} Amount*1/ $(Columndim89)/1000),

it return correct value. for both chart 1 and 2. ( show the same value , meaning is correct )

My Question is why i don't need to change the expression to below at chart 2 , during eEVENUE :-

After i change the expression to below , it work fine :-

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

yet i am using below expression , yet is working fine :-

Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim601) ={$(ColumnDim601)}>} Amount*1/ $(Columndim89)/1000),

Can some one share with me why ?

Paul

1 Reply
paulyeo11
Valued Contributor II

Re: WHY CHART 2 ONLY WRONG FOR nET_PROFIT ?

My QV Doc

Community Browser