topic Re: Two calendar with from and to dates in QlikView

Two calendar with from and to dates

renjithpl — Wed, 27 Nov 2013 13:16:24 GMT

Hi All,

I have two date fields, one is Trade_Date and seconde one is Maturity Date.

Now i want to have two from and to date options, (pls see attachment)

User will able to select both ranges in Trade date and maturity date, and click on a button.

All the trades happend in that date range and out of that how many matured in the range of maturity date should be displayed.

Please let me know if you need more clarity on this.

Thanks

Ren

Clever_Anjos — Wed, 27 Nov 2013 13:35:47 GMT

1) Create 4 variables and attach calendars to each one

2) Use Set Analysis to filter your data according to variables

Example

SUM({< Trade_Date={">=$(var1)"}*{">=$(var2)"}, [Maturity Date]={">=$(var3)"}*{">=$(var4)"}>}Value)

Wed, 27 Nov 2013 14:25:13 GMT

Hi,

I have made it through Button Click event as well as through SET analysis. See the attachment.

FYI - I just used Trades From and To date.