Variable value in Concat distinct field

kasmurugesan — Fri, 20 Aug 2021 13:03:03 GMT

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.

Re: Variable value in Concat distinct field

MayilVahanan — Sat, 21 Aug 2021 02:20:24 GMT

Try like below

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

Make sure, date format is same like ur field.

Re: Variable value in Concat distinct field

kasmurugesan — Mon, 23 Aug 2021 04:42:38 GMT

Hi Mayil Vahanan,

Thanks for your quick solution.

topic Variable value in Concat distinct field in QlikView

Variable value in Concat distinct field

Re: Variable value in Concat distinct field

Re: Variable value in Concat distinct field