topic Logic to be implemented in QlikView

Logic to be implemented

Mon, 09 Apr 2012 03:48:13 GMT

Hi! i have one senario to be implemented.

I have sample data in the excel attached. As shown i have the data row wise and i want the report column wise as shown.In the excel i have given example for one ID. In my data i have lot of ID's so i want to build a report for all such id. And progress id's coresponding to one ID are not fixed they are mutiple.

So could someone help me on this logic.

pls let me know in case you need some more information.

thanks

ronny

Re: Logic to be implemented

adhudson — Mon, 09 Apr 2012 05:43:42 GMT

Hi,

Please find the Attached file.

Hope this helps.

Regards

Andrew Hudson

Logic to be implemented

Mon, 09 Apr 2012 05:44:45 GMT

Hi,

Please clarify some doubts below:

How many other Assigned teams do you have?

And For each other assigned team do you need a saparate fields.

Thanks,

Niranjan M.

Logic to be implemented

Mon, 09 Apr 2012 06:57:29 GMT

Hi Niranjan

--other assigned teams can be multiple, there is no fixed no. for it

-- I dont need a separate field for other assigned team, i need them in a row against there corresponding ID as shown in the excel.

Also i want to shown this for many id whichy are there in my actual data . In the sample data i have provided data only for one ID. Pls send me a general logic which i can apply on all my data and get the desired output.

thanks in advance..