topic How do i write set analysis?? in QlikView

How do i write set analysis??

Mon, 24 Dec 2012 09:58:56 GMT

Hi All,

for example this is my data.

item Date ord_no Rate

123 2011-jan-17 1 22

123 2011-mar-18 2 12

145 2011-feb-19 3 30

145 2011-mar-20 4 13

165 2011-jan-30 5 15

165 2011-mar-01 6 17

165 2011-mar-31 7 255

if i select financial year like 2011-2012 i need last year means upto 31-3-11 max ord_no corresponding rate.

item wise.

My result like this i need:

item rate

123 12

145 13

165 255

Thanks,

Ashok.

Re: How do i write set analysis??

sujeetsingh — Mon, 24 Dec 2012 10:19:10 GMT

Just go with following link and it will help you to set analysis...

http://community.qlik.com/servlet/JiveServlet/previewBody/1867-102-1-1858/QlikLearn-Set-Analysis-Presentation.pdf

Re: How do i write set analysis??

jagan — Mon, 24 Dec 2012 10:23:03 GMT

Hi Ashok,

Hope attached file helps you.

Regards,

Jagan.

Re: How do i write set analysis??

CELAMBARASAN — Mon, 24 Dec 2012 10:54:50 GMT

First Sorted value help you here.

Item as dimension

=FirstSortedValue(Rate, -OrdNo)

Hope it helps

Re: How do i write set analysis??

Mon, 24 Dec 2012 11:17:53 GMT

Hi,

that function is working for current year but i need last year max date rate.

Re: How do i write set analysis??

Mon, 24 Dec 2012 11:29:11 GMT

see this link

http://community.qlik.com/thread/64070

Re: How do i write set analysis??

er_mohit — Mon, 24 Dec 2012 12:40:11 GMT

-FirstSortedValue(OrdNo,-Rate)

hope it helps you

Re: How do i write set analysis??

CELAMBARASAN — Mon, 24 Dec 2012 12:57:18 GMT

Then use set analysis in that function

=FirstSortedValue({<YearField={$(=Max(YearField)-1)}>} Rate, -OrdNo)

Re: How do i write set analysis??

Tue, 25 Dec 2012 05:26:34 GMT

Hi,

but it's giving all zero's.

Re: How do i write set analysis??

Wed, 26 Dec 2012 09:13:15 GMT

Hi,

Thanks,it's working perfectly.