Comments for countnazgul.com

Comment on QlikView – Export chart data on specific date to xls file by countnazgul

countnazgul — Tue, 02 Dec 2008 09:52:55 +0000

Well actually this is the part of commented line. Line was too long and wordpress move it to new line :-)
I edit the post and this line is commented too.

Thanks for response! :-)

Comment on QlikView – Export chart data on specific date to xls file by JFK

JFK — Tue, 02 Dec 2008 09:40:00 +0000

Hi, thankz for the code; it’s very useful.

however, if I use the “name: Projects_Bulgaria.xls” property, it says “Type mismatch: ‘name’”.
What exactly does the part do? The macro seems to run fine, if I just disables the line

Comment on QlikView – extract data from comma separated cell by countnazgul

countnazgul — Fri, 19 Sep 2008 09:35:06 +0000

Hahaha thanks Chris! :-) i was surprised when i didn’t find easy way :-) But obviously i didn’t look hard :-)
Tanks again.

Comment on QlikView – extract data from comma separated cell by ChrisF

ChrisF — Fri, 19 Sep 2008 08:45:59 +0000

Load
ID,
subfield(Users,’,') as Users
FROM [C:\Users.xls] (biff, embedded labels, table is [Users$])

Will also achieve what your trying to do.

Regards
Chris

Comment on QlikView – extract data from comma separated cell by countnazgul.com » Blog Archive » Diigo bookmarks 09/18/2008 (p.m.)

countnazgul.com » Blog Archive » Diigo bookmarks 09/18/2008 (p.m.) — Thu, 18 Sep 2008 21:33:42 +0000

[...] countnazgul.com » QlikView – extract data from comma separated cell [...]