Sum with variable dates

[#1]

Hi All

I am unable to convert other answers to my file - I am new to QV, so am hoping someone can help:

I am trying to create a straight table showing:

Date1

Date2

Difference

I created variables for Date1 and Date2 to create a calendar for both, hoping to sum the number of complaints per area within a certain week: [Complaint_Weekend].

Is someone able to help with the Syntax for this, it would be much appreciated! So it should look something like

Sum of number of Complaints with [Complaints Weekend] = vDate1

Sum of number of Complaints with [Complaints Weekend] = vDate2

then the difference between the two.

Thanks in advance

Neil Allen

[#2 · Accepted solution]

There is nothing to be sorry for. QV is easy to learn just give it some time

The format is to be added to the expression. For instance my original post

Sum({<[Complaints Weekend] = {"$(vDate1)"}>} numberofComplaints)

should be changd to

Sum({<[Complaints Weekend] = {"$(=date(vDate1))"}>} numberofComplaints)

If the problem persists can you share your qvw for us to debug?

Kiran.

[#3]

Thanks so much for you help Kiran!!!!!

Neil

[#4]

Excellent post. Very helpful.