topic Re: Sum over the records in QlikView

Sum over the records

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have two dates in a table:Date1 and Date2. I want to sum Revenue in the chart using Date1 as a dimension but over the all the records where Date2 = Date1 (kind of parent ). Can someone help with this?

thank you,

Olivera

Re: Sum over the records

Anonymous — Wed, 25 Mar 2015 01:20:44 GMT

Sum(if(date1=date2,amount))

Re: Sum over the records

Wed, 25 Mar 2015 01:26:07 GMT

Hi,

this is the sum over the range of records. Date 2 and Date 1 will not be the same for the same record, but Date 1 in one record might be equal to Date 2 in some other record

Re: Sum over the records

Wed, 25 Mar 2015 02:15:40 GMT

Hi,

Try like this

Create a Temparory Table having Date2 field and rename it to Date1. Then concatenate the TempTable with main table which is having only Date1 then create the the chart

Select * from Table;

concatenate

TempTable:

Load Date2 as Date1,Revenue resident Tablename;

Regards

Harsha Nandan

Re: Sum over the records

Wed, 25 Mar 2015 02:24:42 GMT

Thank you,

yes that is one of the solutions but I thought that it might be done with some formula on front end,

Olivera

Re: Sum over the records

ramoncova06 — Wed, 25 Mar 2015 03:20:01 GMT

best solution is on doing this at script level, it would allow a better performance, doing those kind of if's can consume a lot of cpu