topic contract yr in QlikView

contract yr

rajni_batra — Mon, 14 Oct 2013 07:03:12 GMT

Hello ,

I have attached a dummy file to explain my problem, In sheet one there is a contract with given Valid from valid to date

and in sheet 2 there is year on year variance for same contracts,

In sheet 3 i have mentioned the output desired.

i.e. if two contracts have diff valid from date but user wants them to be in a single column for there respective 1st contractual , 2nd contractual year and so on .

Any help would be appreciated!!! thanks

Regards,

Rajni

Re: contract yr

rajni_batra — Mon, 14 Oct 2013 11:09:04 GMT

Any suggestions on this plz

Re: contract yr

Gysbert_Wassenaar — Mon, 14 Oct 2013 16:56:07 GMT

See attached qvw.

Re: contract yr

rajni_batra — Tue, 15 Oct 2013 06:11:33 GMT

Thanks Wassenaar!!! This is really helpful..

Will ask if i stuck at any point,,,,

Thanks Again

Regards,

Rajni

Re: Re: contract yr

rajni_batra — Thu, 24 Oct 2013 06:43:05 GMT

Hello G,

again i need ur help hope u will help me out

Described the desired output in sheet 3 .

Regards,

rajni