topic Re: Set analysis in QlikView

Set analysis

rcandeo — Tue, 04 Oct 2011 13:56:10 GMT

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

Set analysis

GabrielAraya — Tue, 04 Oct 2011 14:00:47 GMT

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

Set analysis

rcandeo — Tue, 04 Oct 2011 14:04:25 GMT

Thank You

Re: Set analysis

Wed, 06 Mar 2013 09:54:14 GMT

how to find 3 year of data using the set analyst

Re: Set analysis

sushil353 — Wed, 06 Mar 2013 10:18:13 GMT

try

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

Re: Set analysis

Thu, 07 Mar 2013 06:05:49 GMT

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

Re: Set analysis

sushil353 — Thu, 07 Mar 2013 06:17:42 GMT

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

Re: Set analysis

preminqlik — Thu, 07 Mar 2013 09:41:48 GMT

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

Re: Set analysis

Thu, 07 Mar 2013 10:46:23 GMT

thanks