Help with exporting data

[frata]

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

[BawejaMedia]

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]

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.