Discussion Board for collaboration on QlikView Scripting.
Thanks Ajay for your reply but your logic is not working.
If you select Feb 2014 from field Monthname and Select India from field State it will show you 6 Tickets whereas from your formula i am getting 1 Ticket.
For the selections you mentioned the max date in Completed Date is 27/02/2014 for which there is just one
TicketID - 110.
Should a different logic be used to calculate that.
Use this as your expression
Checked enclose file,