Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amirkachlon
Contributor III
Contributor III

Import Number of CALS Allocated to document

Hi all,

I need to get this number for each document on my QVC,

meaning I want to run a process that returns a list of document names and number of aloocated documents (in this case 11).

I tried this : Qlikview Server CAL Manager, and I couldnt generate this data.

Any other ideas ?

Regards,

Amir

ss.PNG

1 Solution

Accepted Solutions
flipside
Partner - Specialist II
Partner - Specialist II

Hi Amir,

Using QVS CAL Manager via a command line, you can use the -documents switch to export this data to Documents.xml. The data is in field DocumentCALsAllocated.

flipside

View solution in original post

6 Replies
datanibbler
Champion
Champion

Hi Amir,

if you search for "analyze CAL allocation" or so, there is a how-to (here in the Community) to edit an .ini file in your QlikView installation so that a CalData.pgo.xml file gets written daily (in addition to the CalData.pgo that you have already) which QlikView can read. There is an app somewhere on the Community that can read that xml file and draw all the CAL data from it.

HTH

flipside
Partner - Specialist II
Partner - Specialist II

Hi Amir,

Using QVS CAL Manager via a command line, you can use the -documents switch to export this data to Documents.xml. The data is in field DocumentCALsAllocated.

flipside

amirkachlon
Contributor III
Contributor III
Author

any script to loop all documnets and get this data from the xml file to two rows of ; delimted txt file?

will be great !!

thanks!

flipside
Partner - Specialist II
Partner - Specialist II

Qlikview can read in the xml file and can store it back out as a delimited flat file using something similar to below ...

STORE Data into data.ssv (txt, delimiter is ';');

flipside

amirkachlon
Contributor III
Contributor III
Author

cmd line will be much better

flipside
Partner - Specialist II
Partner - Specialist II

I don't think there is an option to choose a different output format but I could be wrong - try posting the query on the QVS CAL Manager link.