Set analysis

[rcandeo]

Please, how can I do that?

I have fields date, month, year and quantity and wanna show in a dinamic table the sum of the quantities of the month and year selected, disregarding the day that is selected.

So I will be the sum of the day and the sum of the month.

Thank You in advance

[GabrielAraya · Accepted solution]

Hi,

If you have 3 fields: Year, Month and Day and you want to show the sum of quantities but only for the month and year selected you need: Sum({<Day=>} Quantity)

Gabriel

[rcandeo]

Thank You

[#4]

hi

how to find 3 year of data using the set analyst

[sushil353]

try

sum({<year={">$(=max(year)-3) <=$(=max(year))"}>}value)

[#6]

hi

friend's

I have year 2003,2004,2005,2006,2007

then how to get max(year), min(year) hear i get max(year) from ctrl+alt+v Vmax=max(year) but not get Vmin=min(year) 

Find this only from frant end  ctrl+alt+v

Reply fast

[sushil353]

didn't got your issue,

try to rename the field Year like Year_t for testing..

And then see the issue.. or else upload your application or screenshot

[preminqlik]

i think question is  to get last three years of data in chat ?

do this

declare variables For Eg: VmaxD=max(Year)
VminD=VmaxD-2

and in expression

=Sum({$<Year={"<=$(=VmaxD)>=$(=VminD)"}>}Fieldname)

-Regards

premhas

[#9]

thanks