Data Load from excel and filteration

Fri, 12 Feb 2016 13:19:13 GMT

I am loading data directly from excel which are having many columns. Sample format of the data is below

Now I need to summarize the data information from this loaded table. The summarized data should contain one row value for a specified date having max value for the column power.

ie for 11/10 the i need the 3rd row (4225) of the data and for 10/10 the selected row will be the last ( 4230)

Appreciate your help in creating a load script to achieve this in qlik sense.. I am a beginner in using this application.

Regards

Re: Data Load from excel and filteration

Gysbert_Wassenaar — Sat, 13 Feb 2016 14:32:25 GMT

You can create a flag field in the script by joining the table with a summary table:

Table1:

LOAD * FROM ...excel_file...;

JOIN (Table1)

LOAD

[Date/Time],

VILLA_ID,

Max(Power) as Power,

1 as IsMaxPowerRecord

RESIDENT

Table1

GROUP BY

[Date/Time],

VILLA_ID

;

You can then use the new field IsMaxPowerRecord (or whatever you decide to us as field name) to filter the data.

topic Data Load from excel and filteration in QlikView

Data Load from excel and filteration

Re: Data Load from excel and filteration