Create XLS table for multiple selection/tables in one sheet

Wed, 07 Sep 2011 12:30:13 GMT

I have the 2 following questions for help

I have a table of 5 fields of "moving date, Area, City, country and the cost"

I need to create an XLS file with the moving date, and showing the total of cost for each area, with 2 columns on the same sheet for the total cost of 2 specific cities in table, so my XLS should be as the following

Date, total cost of area, total cost of City1, total cost of City 2

Appreciate your help

the 2nd question, is how to set a default value for the selection based on another field selection, for example

I select a 'selection 1' from table 1, and I need automatically to set certain values from table 2 based on the earlier selction

many thanks for support

topic Create XLS table for multiple selection/tables in one sheet in QlikView

Create XLS table for multiple selection/tables in one sheet