Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macros

Hi,

I want to know how to select range of dates in the listbox when selecting start date and end date in the inputbox using macros??

Please help me out!!

2 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi Gaayathri,

This is possible by using Set Analysis. I am not sure why you wanted to use the Macros. I would recommend you to avoid using Macros whenever possible, unless you have different requirement.

I am attaching an example for your reference. Here is the function I have used to get this working.

SUM( {<MyDate ={">=$(vStartDate) <=$(vEndDate)"} >} Sales)

Where vStartDate and vEndDate are variables which capture the Input Field Values.

I hope this helps! Let me know if you have any questions.

Cheers,

DV

Not applicable
Author

Hi DV,

Thanks a lot!!!! I got it

Regards,

Gaayathri