Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
suresh_qv50
Creator
Creator

Need one Year Fled from 2 dates

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

5 Replies
veeranj
Creator II
Creator II

Hi Suresh,

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

Regards,

Anjee

Gysbert_Wassenaar

See this blog post: Canonical Date


talk is cheap, supply exceeds demand
ganeshsvm
Creator II
Creator II

Hi,

Post some sample data in XL.

Regards,

Ganesh

suresh_qv50
Creator
Creator
Author

Hi Please find the sample data

ganeshsvm
Creator II
Creator II

Hi Suresh,

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

Regards,

Ganesh