topic How to get the count by equating two date fields in QlikView

How to get the count by equating two date fields

ravindraa — Fri, 14 Nov 2014 12:59:03 GMT

Hi all,

I am stuck in one place please give me any suggestion on this to come out from the issue.

i have 2 date fields "expecteddate" and "deliverykey(Datefield)" field . Also one Dealerkey value .

I have to get the count of Dealer key when the date(expecteddate and deliverydate) are equeal.

We have tried with different expressions but unable to get to exact count.

if the data is sorted in backend that will impact on my entire application i need frent end expression please give me any suggesion.

Kindly suggest some solution for the same.

Please check the below attachments.

Please give me any suggesion.

Thanks in advance.

Re: How to get the count by equating two date fields

Anonymous — Fri, 14 Nov 2014 13:03:53 GMT

maybe I am looking in the wrong place, but I cannot find "deliverydate" field in your attachments.

Re: How to get the count by equating two date fields

alexandros17 — Fri, 14 Nov 2014 13:08:36 GMT

Use a straight chart

Use Dealerkey as dimension and add the following expresison

Sum(if([Delivery key]=ExpectedDate,1,0))

let me know

Re: How to get the count by equating two date fields

ravindraa — Fri, 14 Nov 2014 13:11:20 GMT

Sorry , Bill Markham,

Please check now i have modified my mistake .

Re: How to get the count by equating two date fields

ravindraa — Mon, 17 Nov 2014 04:00:58 GMT

Hi Alessandro Saccone,

Thanks for helping but it is working for excel data but i have applyed same expression in my app with real time data but it has to be show 495 but it is showing 295, actuvaly i have mentioned same date formate and same fields. pleas give alternative suggision.

Please give any suggesion.

Thansk in advance.