Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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