topic Set Analysis problem? in QlikView

Set Analysis problem?

khadeer — Wed, 26 Dec 2012 09:22:19 GMT

Hi All,

I have date field with 2005 to 2012, and amount field with some values. Suppose if i selected for year wise and month wise i am getting correct values.

But if i want data from starting onwards. for example, if i selected year 2010 and month june ... i want the total value from 2005 to selected date that means (2010 june).

Regards,

Khadeer

Re: Set Analysis problem?

Wed, 26 Dec 2012 09:38:16 GMT

TRY IT

SUM(TOTAL( $<YEAR AND MONTH>AMOUNT))

Re: Set Analysis problem?

Wed, 26 Dec 2012 09:41:03 GMT

Hi khadeer,

Can you share your file, please?

-Anju

Re: Set Analysis problem?

khadeer — Wed, 26 Dec 2012 10:01:18 GMT

Hi Vishwa,, Its not working..... Hi Anju, PFA

Re: Set Analysis problem?

Wed, 26 Dec 2012 10:06:42 GMT

Hi,

Can you also please attach your .qvw file?

-Anju

Re: Set Analysis problem?

khadeer — Wed, 26 Dec 2012 10:11:46 GMT

Just i given one example i cant share my qvw.. file. If i selected 2012 i have to show total amount. If i selected 2011 i have to show until 2011.... if i selected 2011 n any month i ave to show amount from starting date to selected date. I hope its clear. regards, Khadeer

Re: Set Analysis problem?

Gysbert_Wassenaar — Wed, 26 Dec 2012 10:30:42 GMT

Try: sum({<Date_Field={"<=$(=max(Date_Field))"}>} Amount)

Re: Set Analysis problem?

khadeer — Wed, 26 Dec 2012 10:35:03 GMT

i have tried this already. But its not working. Its giving total value just like sum(Amount)

Re: Set Analysis problem?

Wed, 26 Dec 2012 10:45:59 GMT

Hi,

I think we have to use something like this

=sum({<Date={">=$(=Date)<=$(=max(TOTAL Date))"}>} Amount)

but, this again needs some modification =$(=Date) gives current date and =max(TOTAL Date) gives the last date in the list. I tried this, but I am still getting values for only that particular date.For some reason, it is not summing it.

-Anju

Re: Set Analysis problem?

khadeer — Wed, 26 Dec 2012 10:55:37 GMT

Hi Anju, Not working. Still its pending.

Re: Set Analysis problem?

er_mohit — Wed, 26 Dec 2012 11:10:29 GMT

hey try this

sum({<Date_Field={"<=$(=max(Date_Field))"}>}TOTAL Amount)

might be helpful

Re: Set Analysis problem?

khadeer — Wed, 26 Dec 2012 11:43:32 GMT

Thank u mohhit n wassener, Both r helpful

In wassener post just create variable with =max(Date_Field) and use that varible in chart we r getting answer.