topic Re: How to Use a Column in SUM Expression in QlikView

How to Use a Column in SUM Expression

Mon, 26 Jan 2026 18:19:17 GMT

HI, I am trying to use one column as an filter condition for my sum Expression, like this: =SUM({} EngedMem_Rnk) Where Date is a column in my data set, but it’s not working. If I remove Date condition from my expression, its working fine. =SUM({} EngedMem_Rnk) Any idea, what I am missing I need to Include Date Column in my sum Expression. Thanks Sandeep

Re: How to Use a Column in SUM Expression

v_iyyappan — Mon, 09 Sep 2013 20:36:39 GMT

Hi,

Use like this for max date filter using set analysis:

=Sum({<DateField={"$=(max(DateField))"}>}EngedMem_Rnk)

Regards,

Re: How to Use a Column in SUM Expression

Mon, 09 Sep 2013 20:38:07 GMT

Hi Sandeep,

What date condition you are writing? Please elaborate your problem or provide qvw.

Regards,

Anosh

Re: How to Use a Column in SUM Expression

Mon, 09 Sep 2013 20:46:49 GMT

Hey Anosh, I am trying to calculate my SUM on the basic of three conditions, like bellow =SUM({} EngedMem_Rnk) Where in first condition DateType = {3}, 3 is an value I am putting. first condition ENG_DATE = {Date}, Date is a Column in my Data Set, from which I need to calculate.

Re: How to Use a Column in SUM Expression

Mon, 09 Sep 2013 20:49:43 GMT

It's not working, I have a question, why I should use Max, as I said Date is a column, value of date column for each row should get considered while calculation.

Re: How to Use a Column in SUM Expression

Mon, 09 Sep 2013 20:58:33 GMT

Hi Sandeep,

Set analysis doesn't calculate RHS clause row by row. for eg if expression is: sum({<Year={abc}>} amount) where abc is caculated only once and used in all records, thats why it should be Max,Min or something else to return only one value. If you want to use Date in your calcuation then put Date colume in dimension and the expression will automatically start taking it into consideration.

Hope this help,

Anosh