How to date filters within a month field

[#1]

Hi All,

I want to add date filters to the month field. E.g. I want to be able to click on Dec and get the following dates to be filtered out.

Click on Dec under Monthly field and get

linestartdate <= '12/31/2015' 

lastbilldate > '11/30/2015'

linecanceldate > '12/31/2015'.

Thanks in advance,

[harsh44_bhatia]

Hi,

You have to apply macros on d2.MONTHLY field.

Based on the values selected you have to code in macro to select the date ranges in the other three list boxes.

let me know if u need help on the macros.

[MK_QSL]

You can use trigger for that... Provide sample data to work.

[#4]

Hi,

I have never done Macros in Qlikview. Can you guide me on how to implement it?

for the Month = Dec

Line Start <=12/31/2015 for Nov this would be 11/30/2015

Bill Date > 11/30/2015 for Nov this would be 10/31/2105

Cancel Date > 12/31/2015 fro Nov this would be 11/30/2015.

and so on with the months.......

Please I want to automate these also so I won't have to put up with the hassle of updating it monthly.

Thanks,

[#5]

Hi Manish,

Please find attached the sample data.

I want to click on Jan and want to have the following dates to be filtered out within it.

linestartdate <= '01/31/2015' for Feb this would be 2/28/2015

lastbilldate > '12/31/2014' for Feb this would be 1/31/2015

linecanceldate > '01/31/2015 for Feb this would be 2/28/2015

Likewise for March, April, etc....

Thanks,