How to comnine 2 different expression into 1 using if ?

paulyeo11 — Wed, 10 Feb 2016 12:32:55 GMT

Hi All

I have expression for table 1 as below :-

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

When i Press on Button STep 1 , table 1 will display 1871.

I have expression for table 2 as below :-

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

When i Press on Button STep 2 , table 2 will display 1877.

May i know how to combine above 2 expression into 1 ? So that when i press button step 1 it will display 1871 and when i press step 2 it will display 1877 in table 3.

My imagine expression for table 3 is below :-

=IF([[Pls select 66 Dim]] = 'rEVENUE',

(

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

IF([[Pls select 66 Dim]] = 'sales',

(

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

))

But cannot work.

next post i will send my QV Doc

Paul

Re: How to comnine 2 different expression into 1 using if ?

paulyeo11 — Sat, 20 Feb 2016 00:19:48 GMT

Already settle.

topic How to comnine 2 different expression into 1 using if ? in QlikView

How to comnine 2 different expression into 1 using if ?

Re: How to comnine 2 different expression into 1 using if ?