Discussion Board for collaboration related to QlikView App Development.
I have an Requirement,
we have 2 table, from one table getting Issued date--> derived Year from Issued date
From Another table we have Expiry date --> Derived Year from that date.
Its like a debit card, Now we nee to show in UI
When i select one Year in List box, we need How many cards issued in that year & How many are expired.(We need only one year field list box instead of 2)
In same aspect Month Wise too
Try concatenating two Date Fields and add flags like ' Issued' and 'Expired' and use these flags to count .
See this blog post: Canonical Date
Post some sample data in XL.
Hi Please find the sample data
Canonical date is the best solution for you data, as posted by gwassenaar.