Multiple selection on enter in a sheet

danosoft — Thu, 24 Oct 2019 08:35:07 GMT

Hi i need to do a multiple selection of my months when i enter in my sheet.

for now i put this expression in the action:

=num(month(now())-2,'00')

but this only select my month-2 (example 08)

I need to select not only the 08 but all months beofre 08, so: 08,07,06,....01

my field name is: MESE_COMP

what kind of expression i need to put in the action for make that selection?

thanks

Re: Multiple selection on enter in a sheet

tresB — Thu, 24 Oct 2019 08:58:37 GMT

Try like:

='<='&num(month(now())-2,'00')

Re: Multiple selection on enter in a sheet

danosoft — Thu, 24 Oct 2019 09:09:14 GMT

Hi, thanks this work for the selection of my months, but in my expression in my text box it do an error:

Error: Error in expression: ')' expeded

my expression is this (if i choose months manually all work good)

='Performance Mese' & chr(10) &

if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='01','Gennaio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='02','Febbraio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='03','Marzo',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='04','Aprile',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='05','Maggio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='06','Giugno',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='07','Luglio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='08','Agosto',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='09','Settembre',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='10','Ottobre',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='11','Novembre',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='12','Dicembre',''))))))))))) )

and i have in my chart a set analisys like this and in your way not work:

num(Sum({<MESE_COMPETENZA={"$(=num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00'))"}>} CONSUMO_SMC),'#.##0;(#.##0);-'),

topic Multiple selection on enter in a sheet in QlikView

Multiple selection on enter in a sheet

Re: Multiple selection on enter in a sheet

Re: Multiple selection on enter in a sheet