topic Re: Help with exporting data in Connectivity & Data Prep

Help with exporting data

frata — Sat, 06 Apr 2024 12:33:00 GMT

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

Re: Help with exporting data

BawejaMedia — Sat, 06 Apr 2024 14:05:56 GMT

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

Open your QlikView application and navigate to the sheet containing the table you want to export.
Right-click on the table you want to export.
Select "Export" from the context menu.
Choose the desired format for export, such as Excel or CSV.
Save the exported file to your desired location. Also, check out Baweja Media

Re: Help with exporting data

Vegar — Sun, 07 Apr 2024 08:45:08 GMT

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.