topic Set analysis in QlikView

Set analysis

Fri, 18 Oct 2013 05:00:00 GMT

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.

Re: Set analysis

Fri, 18 Oct 2013 05:11:34 GMT

the Start Period is a Field then period,quarter and years is data ?

Re: Set analysis

sujeetsingh — Fri, 18 Oct 2013 05:17:25 GMT

Please explain the outcome of your expression what you want.

Re: Set analysis

jyothish8807 — Fri, 18 Oct 2013 05:28:24 GMT

Try this,

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

Use a [ ] at Start Period.

Regards

Jyothish KC

Re: Set analysis

Fri, 18 Oct 2013 05:32:01 GMT

here start period values are period start date,quarter start date,year startdate,

these are also fileds

Re: Set analysis

er_mohit — Fri, 18 Oct 2013 05:32:48 GMT

Try this

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

Re: Set analysis

Fri, 18 Oct 2013 05:38:00 GMT

i already try this,but this is also not working

here start period representing another field values

Re: Set analysis

Fri, 18 Oct 2013 05:39:09 GMT

i think the Start Period is Table name and the date,quarter and yearstartdate are field of Start Period ?

Re: Set analysis

NavinReddy — Fri, 18 Oct 2013 05:42:35 GMT

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

remove '=' and try

Re: Set analysis

tresB — Fri, 18 Oct 2013 05:43:17 GMT

Please share your sample app.

Re: Set analysis

Fri, 18 Oct 2013 09:14:32 GMT

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

Re: Set analysis

Fri, 18 Oct 2013 09:15:59 GMT

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

Re: Re: Set analysis

tresB — Fri, 18 Oct 2013 09:38:35 GMT

May be like attached sample?

Re: Set analysis

Fri, 18 Oct 2013 11:07:48 GMT

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

Re: Set analysis

Fri, 18 Oct 2013 11:19:15 GMT

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

Re: Set analysis

tresB — Fri, 18 Oct 2013 11:27:29 GMT

Try this expression in my sample app:

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