topic Need Help in QlikView

Need Help

paulwalker — Wed, 17 Jun 2015 02:56:27 GMT

Hi Community,

I Need Help,

I have one Excel datasource.. like this

ABC	Employee	Employee1	75281
	Employee	Employee2	40930
	Department	Department1	40711
	Department	DEpartment2	41037
BCA	Employee	Employee1	130256
	Employee	Employee2	53922
	Department	Department1	2319
	Department	DEpartment2	18469
CBA	Employee	Employee1	2480275
	Employee	Employee2	976329
	Department	Department1	3056
	Department	DEpartment2	19556

Thanks in Advance....

PFA,

Re: Need Help

Wed, 17 Jun 2015 04:24:23 GMT

Hi,

Please go through the attachment.

Regards,

Jemimah

Re: Need Help

paulwalker — Wed, 17 Jun 2015 10:18:56 GMT

Please anyone can help me???

Re: Need Help

petter — Wed, 17 Jun 2015 10:44:20 GMT

The solution Jemimah gave you is fine for the CROSSTABLE part and you could just quick-fix that with adding this to the end of his load script:

Tab2:

NOCONCATENATE LOAD

Code,

Pick( Match( Col, 'Employee1', 'Employee2' , 'Department1', 'Department2' ) , 'Total Customer','Tot Unique','Total Dept' , 'Tot Dept Unique' ) AS Col,

Value,

Column

RESIDENT

Tab1;

DROP TABLE Tab1;

And it will work fine. I attached a modifed QVW. But I used a BINARY load since I didn't have the source Excel file.

Re: Need Help

paulwalker — Wed, 17 Jun 2015 11:45:37 GMT

Thanks Peter....

Re: Need Help

petter — Wed, 17 Jun 2015 11:47:04 GMT

Actually it was Jemimah that solved the crosstable for you so please mark his contribution as helpful and like his solution too so he gets some points for it.

Re: Need Help

paulwalker — Wed, 17 Jun 2015 11:54:53 GMT

Yeah, Your right...

Thanks..

Re: Need Help

paulwalker — Wed, 17 Jun 2015 11:56:00 GMT

Hi Jemi,

Really, it's very helpful to me.....

Thank you so much for Quick response................