topic AW:QVD & Qualify in QlikView

QVD & Qualify

Thu, 16 Jul 2009 16:32:59 GMT

Hello everybody!

I'm using the Server Perf Dashboard and i want to enhance the load by using QVD.
In order to process this, this is my code:


Load
 Timestamp,
 left(Timestamp, 13) as DateHourKey,
 Time(Timestamp) as PerformanceTime,
 Timestamp as PerformanceTimestamp,

 [Exe Type] as ServerExeType,
 [Exe Version] as ServerExeVersion,
 EntryType,
 ActiveDocSessions,
 DocSessions,
 ActiveAnonymousDocSessions,
 AnonymousDocSessions,
 ActiveTunneledDocSessions,
 TunneledDocSessions,
 DocSessionStarts,
 ActiveDocs,
 RefDocs,
 LoadedDocs,
 DocLoads,
 DocLoadFails,
 Calls as PerformanceCalls,
 Selections as PerformanceSelections,
 /*ConnectionAttempts,
 ConnectionRejects,
 ConnectionPurges,*/
 ActiveIpAddrs,
 IpAddrs,
 ActiveUsers,
 Users,
 CPULoad,
 [VMCommitted(MB)],
 [VMAllocated(MB)],
 [VMFree(MB)],
 [VMLargestFreeBlock(MB)]
FROM QVS_Generation_QVD\Performance*.log (utf8, txt, delimiter is '\t', embedded labels);
qualify *;
Perf2008:
LOAD
 *
RESIDENT Performance
 WHERE
 Year(Timestamp)='2008';

STORE Perf2008 into Performance2008.qvd;

Indeed, if i don't use the "qualify *", when i want to store the table, QlikView popups "Table not found".
However, i want finally to create QVD and use them with the Logs.

This way create a QVD with all fields prefixed by Perf2008, does anyone know a way to "undo" this when reloading the QVD in order to integrate it ?

AW:QVD & Qualify

Thu, 16 Jul 2009 16:55:46 GMT

Hi Franck,

i dont´t know any function which could do this. The only way is to cut up the qualification while loading.

Why don´t you load the "Perfomance"-table with date filter and store it directly to qvd? I don´t the see the advantage of loading it again by resident.

Greets

AW:QVD & Qualify

Thu, 16 Jul 2009 19:15:53 GMT

Hi,

I've created the table but I don't know where it's possible to store directly to QVD. When i want to export, i have this list:

Do i need to configure anything to export into QVD?

Thanks a lot 🙂

AW:QVD & Qualify

Thu, 16 Jul 2009 20:12:49 GMT

Hi Frank,

The screen shot you attached is for Exporting Qlikview script but not the QVD.

Exporting QVD happens when STORE command is executed. Instead of Giving file name as performance2008.qvd give the full File path where you want to store QVD file.

Example:

STORE Perf2008 into C:\Performance2008.qvd;

After Reload you can find the QVD file in C:\ Drive.

AW:QVD & Qualify

Wed, 22 Jul 2009 15:27:41 GMT

Well, apparently, you can store into a QVD but only for Charts...

Anyway, thanks for your help !! 🙂