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

How to store an associated value into a variable of the date column using VBScript?

How to store an associated value in a variable of the date column using VBScript?

Example

Emp NameStart DateEnd Date
Hameeda8/1/20148/13/2024
Santhana8/1/20148/13/2025
Kaleel8/3/20148/13/2026
Ganga8/4/20148/13/2026
Siva8/5/20148/13/2028
Sangeetha8/6/20148/13/2029
Avuthu8/6/20148/13/2030

If we select the employee name ,how to capture the corresponding dates (start date and end date) in a variable using macro vb script.

4 Replies
Michael_Tarallo
Employee
Employee

Hi Hameeda - I assume you mean for QlikView correct? - Can you explain more about your case and the product you are using? I will move this thread to the appropriate discussion forum.

Thanks

Mike

Regards,
Mike Tarallo
Qlik
Not applicable
Author

Yes.. It is Qlikview.. I am able to save employee name into an variable using macro.But my requirement is if I select an Emp Name (say hameeda) my script should store the the associated date values into two variables (like vSD=8/1/2014 and vED=8/13/2024) ..

Michael_Tarallo
Employee
Employee

OK, I moved it - if you don't hear anything from someone, please feel free to contact me, and I will do my best to help.

Mike

Regards,
Mike Tarallo
Qlik
Not applicable
Author

Thanks a lot...