topic Re: Sum and Max in QlikView

Sum and Max

Prabhu1204 — Mon, 05 Apr 2021 12:58:08 GMT

I have a Date Filed, Actual field ,Target field

In the UI I have a date picker , On selecting the dates.. say for example jan to march. I need to sum the values between maximum values of each month.

maximum of jan month + max of feb + max of march.

How to do it in load script

Re: Sum and Max

Taoufiq_Zarra — Mon, 05 Apr 2021 12:59:09 GMT

@Prabhu1204 can you share a sample data and the expected output ?

Re: Sum and Max

Prabhu1204 — Mon, 05 Apr 2021 13:19:04 GMT

Re: Sum and Max

Taoufiq_Zarra — Mon, 05 Apr 2021 13:43:21 GMT

@Prabhu1204 for example you can create in load script :

data: load *,Month(Date) as MonthTmp; LOAD Date(Date) as Date, Actual FROM [C:\Users\admin\Downloads\sample input.xlsx] (ooxml, embedded labels, table is Sheet1); load MonthTmp,FirstSortedValue(Actual,-Date) as Value2 resident data group by MonthTmp;

and then for the output use :

sum(Value2)

output:

for jan to feb

until march:

Re: Sum and Max

Prabhu1204 — Mon, 05 Apr 2021 15:58:17 GMT

Its not working for me.. Not sure what i am doing working. One for march i am getting the value