topic Re: Drive Space in QlikView

Drive Space

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I am new to QV, could you tell script to fetch the CD drive space of a local machine?

Deepti

Re: Drive Space

Gysbert_Wassenaar — Wed, 09 Mar 2016 18:33:57 GMT

Can you explain what you mean with "fetch the CD drive space"?

Re: Drive Space

maxgro — Wed, 09 Mar 2016 18:47:08 GMT

for C drive

Execute cmd.exe /C "dir c: > space.txt";

SPACE:

LOAD @1

FROM

space.txt

(txt, codepage is 1252, explicit labels, delimiter is '\t', msq)

Where @1 like '*byte*';

Re: Drive Space

Thu, 10 Mar 2016 06:19:42 GMT

Well, I want to Fetch the available space of the C and D drive of a local machine and store it in QVD.

Re: Drive Space

Thu, 10 Mar 2016 06:26:39 GMT

When I tried to execute the "dir c: > space.txt"; in command prompt. I got message saying access denied.

Please explain in detail.

Re: Drive Space

Gysbert_Wassenaar — Thu, 10 Mar 2016 09:30:37 GMT

First open a command prompt and then execute the command dir c: d: > dirlist.txt. Then open Qlikview and add this to your script:

Data:

LOAD * WHERE len(Drive);

LOAD

if(SubStringCount(previous(line),'Volume in drive'),mid(previous(line),17,1)) as Drive,

If(SubStringCount(line,'bytes free'),trim(TextBetween(line, 's) ',' bytes free'))) as BytesFree;

LOAD [@1:n] as line

FROM [dirlist.txt] (fix, codepage is 1252, no labels)

WHERE SubStringCount([@1:n],'Volume in drive') or SubStringCount([@1:n],'bytes free')

If you want to be able to execute the command line command from inside Qlikview then you first need to disable some security settings so you can do dangerous things like starting arbitrary programs from Qlikview. One of these setting can be found on the Settings tab of the Script Editor: Can Execute External Programs.