Store daily expresion results into QVD file

[#1]

Hello,

My current database doesn't store the amount of open incidents on daily base. I would like to store this information in a qvd file.

Currently i have a straight table wich displays the amount of open tickets.

Calculated dimension = if(TICKETSTATUS_title ='Open', 'Open tickets:')

Expression = count(TICKET_fullname)

I would like to store this like:

Table name= Opentickets

Field 1= date

Filed 2= opentickets

If any more information is needed, let me know.

Thanks, regards, Harry

[Gysbert_Wassenaar · Accepted solution]

You'll have to create a summary table with that information in the script:

Summary:

LOAD

      today() as date,

     count(TICKET_fullname) as opentickets

FROM ...

WHERE match(TICKETSTATUS_title , 'Open','Open tickets')

Concatenate Summary:

LOAD * FROM MyQVD.qvd (qvd);

STORE Summary INTO MyQVD.qvd (qvd);

[#3]

Thanks for the help! i got it working!

Regards,

Harry