Date Selection is not Working

Lakshminarayanan_J — Wed, 15 Sep 2021 11:06:19 GMT

Dear All,

Need a urgent Help on below requirement,

Need to display the data based on Country and Month Selection .

Below Expression is Working Fine if we Select between = Sep20 to Dec20

Expression:

Scenario 1:

=if(COUNTRY='Italy' and (substringcount(GetFieldSelections(MonthYear),'Sep20, Oct20, Nov20, Dec20')),
round(sum({<BRAND=,PRODUCT=>}WEIGHT)))

Scenario 2(Not Working):

if User is Selecting the MonthYear from Sep20 to Apr21 is not working for below selection:

=if(COUNTRY='Italy' and (substringcount(GetFieldSelections(MonthYear),'Sep20, Oct20, Nov20, Dec20,Jan21,Feb21,Mar21,Apr21')),
round(sum({<BRAND=,PRODUCT=>}WEIGHT)))

Kindly Help on resolving the Scenario 2

Re: Date Selection is not Working

stevejoyce — Wed, 15 Sep 2021 12:15:38 GMT

It's probably you are missing spaces between commas in your string after Dec20, this should fix it:

,'Sep20, Oct20, Nov20, Dec20, Jan21, Feb21, Mar21, Apr21'

But I would look for another way to do this that's not so string literal dependent. Maybe:

(getselectedcount(MonthYear) = 8 and min(MonthYear) = 'Sep20' and max(MonthYear) = 'Apr21')

topic Date Selection is not Working in QlikView

Date Selection is not Working

Re: Date Selection is not Working