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: 
kasmurugesan
Contributor
Contributor

Variable value in Concat distinct field

Hi Friends,

 

I need to create action button to select first/last N number of month values in my sheet.

To select value before/after specific date, I have created Text box and added Action(Selection->Select in Field) and used below expression in "Search String" place

='(' & Concat(DISTINCT {<Month = {">=11/01/2020"}>} Month, '|') & ')'

This is working for highlighted fixed value. I have created variable and trying to replace with fixed value. it is not working.

VFMonth=Pick(InputMonth,'10/01/2020','11/01/2020','12/01/2020')   //Created variable

='(' & Concat(DISTINCT {<YYYYMM01 = {">=" & VFMonth& ""}>} YYYYMM01, '|') & ')'

Note: i am using personal edition. Hence request you to not upload .QVW files

 

Please support.

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like below

='(' & Concat(DISTINCT {<YYYYMM01 = {">=$(VFMonth)"}>} YYYYMM01, '|') & ')'

Make sure, date format is same like ur field.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi

Try like below

='(' & Concat(DISTINCT {<YYYYMM01 = {">=$(VFMonth)"}>} YYYYMM01, '|') & ')'

Make sure, date format is same like ur field.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
kasmurugesan
Contributor
Contributor
Author

Hi Mayil Vahanan,

 

Thanks for your quick solution.