topic Re: And in Set Expressions in QlikView

And in Set Expressions

Anonymous — Thu, 19 Nov 2015 04:41:39 GMT

I am typing the following code:

Sum({<Payment_Date = {">$(=vBack_Test_1)"} , Payment_Date = { "<=$(=vPE_Date)" } >} Gross_Claims_Paid)

Basically I want to sum where Payment date is between vBack_Test_1 and vPE_Date. It is applying both condition 1 or condition 2 whereas I want it to sum only those claims between the two dates. If I just apply one condition it works so it means date format and syntax is correct.

Would appreciate some help here.

Re: And in Set Expressions

m_woolf — Thu, 19 Nov 2015 13:00:06 GMT

Try:

Sum({<Payment_Date = {">$(=vBack_Test_1)<=$(=vPE_Date)" } >} Gross_Claims_Paid)

Re: And in Set Expressions

sunny_talwar — Thu, 19 Nov 2015 13:03:23 GMT

or this:

Sum({<Payment_Date = {"$(='>' & $(=vBack_Test_1) & '<=' & $(=vPE_Date))" } >} Gross_Claims_Paid)

Where this -> ='>' & $(=vBack_Test_1) & '<=' & $(=vPE_Date) in a list box should give you the range you want the expression to show and in the same format as Payment_Date

Re: And in Set Expressions

maxgro — Thu, 19 Nov 2015 13:13:28 GMT

Sum({< Payment_Date = {'>=$(=Date(vBack_Test_1))<=$(=Date(vPE_Date))'} >} Gross_Claims_Paid)

maybe you have to remove the Date function

Sum({< Payment_Date = {'>=$(vBack_Test_1)<=$(vPE_Date)'} >} Gross_Claims_Paid)