How to sum the number of records in a QVD file

[john_henry]

I am trying to create an ODAG selections app and I need to sum the number of records in a QVD file.  The following SQL script works when I'm sourcing from a SQL database, however, I am sourcing from a QVD and need to convert the SQL script below to Qlik syntax:

SQL SELECT

SUM(Value),

sum(1) as Total_Line_Items,

Dimension1,

Dimension2

From...

Group By

Dimension1,

Dimension2;

[MayilVahanan · Accepted solution]

HI @john_henry 

Try like below

Load

SUM(Value),

1 as Total_Line_Items,

Dimension1,

Dimension2

From yourSourceQVD

Group By

Dimension1,

Dimension2;

[john_henry]

that worked...thanks!