topic Re: Picking Up Values(Urgent) in QlikView

Picking Up Values(Urgent)

vijetas42 — Wed, 09 Apr 2014 10:58:08 GMT

Hi,

Can any one tell me how to take values within three months in first field first value & from another field last value?

Ex.-I am having data for months start value & End Value

Month Start Value End Value

April 100 200

May 150 130

June 120 100

and I want to pick values from qvd as for Quarter1 100 & 120 which is months start value & months end value
Thanks in advance.

Re: Picking Up Values(Urgent)

Wed, 09 Apr 2014 11:05:29 GMT

Could you be a little bit more specific please.

regards,

Re: Picking Up Values(Urgent)

vijetas42 — Wed, 09 Apr 2014 11:09:55 GMT

Actually my requirement is that, If I am having data monthly I have to calculate quarters & for that to calculate difference between values I have to take first start value of starting month that is april & 100 and for end value ending month of that quarter that is june & end value 100

Re: Picking Up Values(Urgent)

MK_QSL — Wed, 09 Apr 2014 11:14:08 GMT

Can you share sample data?

Re: Picking Up Values(Urgent)

vijetas42 — Wed, 09 Apr 2014 11:25:45 GMT

please refer the original message I have shared sample data

Re: Picking Up Values(Urgent)

rajat2392 — Mon, 14 Apr 2014 06:39:28 GMT

See this thread, you can get the demo application..it is same as your problem....