topic selecting multiple dates on sheet activate in QlikView

selecting multiple dates on sheet activate

Tue, 18 Feb 2014 18:39:34 GMT

I have a standalone list box that has the last four payperiods and need to select the same 4 payperiods in another list box that has a whole big list of pay periods because I need to restrict the dataset that I am displaying in one pivot in my application.

I am using this ='('&Concat(LastFourPayPeriods.PayPeriodEndDT,'|')&')' to select in field on activate but it will not work, the output looks ok but it just will not select the values.

Re: selecting multiple dates on sheet activate

Tue, 18 Feb 2014 18:50:46 GMT

Hi,

Try with this:

='("' & Concat(LastFourPayPeriods.PayPeriodEndDT,'"|"') & '")'

Re: selecting multiple dates on sheet activate

Gysbert_Wassenaar — Tue, 18 Feb 2014 18:52:19 GMT

Maybe this works:

='('&Concat(distinct chr(34) & LastFourPayPeriods.PayPeriodEndDT & chr(34),'|')&')'

If not, you'll have to post more information. For example a sample document that demonstrates the problem.

Re: selecting multiple dates on sheet activate

Tue, 18 Feb 2014 18:55:16 GMT

Thanks this worked for me 🙂