Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
frata
Contributor
Contributor

Help with exporting data

Hi guys,

could someone tell me, how can I export a table from QlikView along with formulas in it? The total SUM is not being calculated correctly an I do not know why. That way i could see it.

thanks

Labels (1)
2 Replies
BawejaMedia
Contributor III
Contributor III

Sure, here's how you can export a table from QlikView along with formulas:

  1. Open your QlikView application and navigate to the sheet containing the table you want to export.

  2. Right-click on the table you want to export.

  3. Select "Export" from the context menu.

  4. Choose the desired format for export, such as Excel or CSV.

  5. Save the exported file to your desired location. Also, check out Baweja Media

Vegar
MVP
MVP

The sum is most likely correct, but it might not be what you expect.

The default behavior of QlikView is to present the total value per dimension on the individual rows, and the whole sum of the expression on the total row (not necessarily the same thing as the sum of rows as you probably use for comparison in excel)

 

Consider this data model.

Load * Inline [

TripID, Passengers, Description

LS, 2, London-Stockholm

LSP, 2, London-Stockholm-Puyang

];

Load * inline [

TripID, LocationInTrip

LS, London 

LS, Stockholm

LSP, London 

LSP, Stockholm

LSP, Puyang

];

The number of passengers are 4, but if you split it up per LocationInTrip then you get

London 4

Stockholm 4

Puyang: 2

TOTAL: 4 (NOT 10)

If you want the total value to be presented as 10 then you need to change the aggregation from default expression total to the sum of rows in the expression properly settings.