Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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

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

View solution in original post

kasmurugesan
Contributor
Contributor
Author

Hi Mayil Vahanan,

 

Thanks for your quick solution.