topic Re: Data Segrigation Issue in QlikView

Data Segrigation Issue

Fri, 04 Oct 2013 13:04:09 GMT

Hi Folks,

my actual table

My Required Data is

Pls help ..

Anonymous — Fri, 04 Oct 2013 14:21:00 GMT

Can you try to explain what exactly are you trying to achieve here..

Sat, 05 Oct 2013 07:05:39 GMT

Dear Aadil,

I need, if distint(count(comm_no)/count(lot_no)) = x

Then First x distinct(Comm_no) Should have first Lot_No

and second X distinct(comm_no) should have Second Lot_NO,

and Third X distinct(comm_no) should have Third Lot_no,

for example see my previous posting

Thanks