QlikView App Dev

[#1]

I'm trying to do set analysis and the date portion isn't doing anything... What is wrong with my syntax? I've attached the file - I tried it two ways.

In the attached file select Dim1 = A and Date = 8/28.

Selected sum Expression1 = 1449

Trying to do the same with set analysis but the sum =2050

='selected sum 1: ' & Sum (Expression1) & ' count of rows: ' & Count (Num) & ' Sum of expression1 where Dim1 = A and AccountStatus= Cancelled and date range: ' & Sum({1<Dim1={'A'},AccountStatus={'Cancelled'},date={">vStart<vEnd"}>}Expression1)

How do I fix this?

[senpradip007]

Try like:

Sum({1<Dim1={'A'},AccountStatus={'Cancelled'},date={">$(vStart) <$(vEnd)"}>}Expression1)

[jagan · Accepted solution]

Hi,

Try like this

=Sum({<Dim1={'A'},AccountStatus={'Cancelled'},Date={">=$(=Date(vStart))<=$(=Date(vEnd))"}>}Expression1)

Note: Qlikview Field names are case sensitive, date and Date fields are not same.  You have to give correct case.

Regards,

Jagan.