topic Re: Need one Year Fled from 2 dates in QlikView

Need one Year Fled from 2 dates

suresh_qv50 — Wed, 14 Dec 2016 07:12:05 GMT

Hi Team,

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

Regards

suresh

Re: Need one Year Fled from 2 dates

veeranj — Wed, 14 Dec 2016 07:45:55 GMT

Hi Suresh,

Try concatenating two Date Fields and add flags like ' Issued' and 'Expired' and use these flags to count .

Regards,

Anjee

Re: Need one Year Fled from 2 dates

Gysbert_Wassenaar — Wed, 14 Dec 2016 07:47:57 GMT

See this blog post: Canonical Date

Re: Need one Year Fled from 2 dates

ganeshsvm — Wed, 14 Dec 2016 07:49:16 GMT

Hi,

Post some sample data in XL.

Regards,

Ganesh

Re: Need one Year Fled from 2 dates

suresh_qv50 — Wed, 14 Dec 2016 08:48:08 GMT

Hi Please find the sample data

Re: Need one Year Fled from 2 dates

ganeshsvm — Wed, 14 Dec 2016 10:40:04 GMT

Hi Suresh,

Canonical date is the best solution for you data, as posted by gwassenaar‌.

Regards,

Ganesh