Set analysis count

[#1]

Hi

I have two date fields DATE1 and DATE2 and I am intending to count ID. How can I write below expression in set analysis.

COUNT(IF(Date1=Date2, ID))

[Anonymous]

Hello,

please assocotea all Dates

Date(yourdate,'DD/MM/YYYY') AS DATE

DO this in all tables

now use Year , month, Day field as list box , like this you can control all dates.

if possible craete a master calendar.

Regards,

anant

[kaushiknsolanki]

Hi,

     Is it possible for you to upload the sample QVW file.

Regards,

Kaushik Solanki

[#4]

Yes Sir. master calendar is created by using DATE1 field. Because it is controlled by DATE1 field and I need the count when DATE1 = DATE2  is selected it counts the total number rather than for that specific date. As explained above. When i pull DATE2 to a list box and specific date the count is right. 

[kaushiknsolanki · Accepted solution]

Hi,

     Find the attachment for clarification.

Regards,

Kaushik Solanki

[#6]

Please find attached.

[kaushiknsolanki]

Hi,

     By joining tables you can do this easily.

     Have a look at the attachment.

Regards,

Kaushik Solanki

[#8]

In the qvw I haave attached. When May 1st 2013 is selected the bar chart gives value as 4 but the line chart returns 41. But when 01/05/2013 is selected in DATE2 field it returns the value 8 which is correct.

Ideally I am looking the chart to display 4 in bar and 8 in line when May 1st 2013 is selected in the calendar.

[kaushiknsolanki]

Hi,

     Have a look at the example attached in my previous post. It does the same as what you want.

Regards,

Kaushik Solanki