Set analysis

[#1]

Hi

i have problem in set analysis

my expression is

sum({<[GL Date]={">=$(=Start Period)"}>}[Net Amount])

here  Start Period  values are  periodstartdate,quarterstartdate,yearstartdate

all date fields are in timestamp format .

if im using expression like

sum({<[GL Date]={">=$(=periodstartdate)"}>}[Net Amount])

this expression working fine.

but problem with start period

how to use these type of values in setanalysis.

[#2]

Hi

here how to write this expression in setanalysis

If([gl date]>=[period start date],sal)

please find attached qvw

in this setanalysis use start period instead of period start date in set analysis expression

please check the script for the start period values

thanks

[#3]

Hi

here how to write this expression in setanalysis

If([gl date]>=[period start date],sal)

please find attached qvw

in this setanalysis use start period instead of period start date

please check the script for the start period values

thanks

[tresesco]

May be like attached sample?

[#5]

Hi tresesco

thanks for u r valuable reply

sum(If([gl date]>=$(=vStartPeriod),sal))  this condition is ok

but i need set analysis expression

please can u give ,how to write set analysis expression for this

[#6]

=sum({<[gl date]>=$(=vStartPeriod)>} sal)

[tresesco]

Try this expression in my sample app:

sum({<[gl date]={"=[gl date]>=$(=vStartPeriod)"}>}sal)