topic variable help in QlikView

variable help

Wed, 27 Mar 2013 16:38:56 GMT

Hi, i need help with this problem i have..

this is my expression..

=$(vDaysInRangeTMP) - sum(AbsentFlag_ISS)

I want to stop the variable from reacting to selections apart from the field [Event Date], the 2nd part of the expression needs to change on selection, so its just the varibable that i want to limit.

Can anyone help please?

Re: variable help

alexandros17 — Wed, 27 Mar 2013 16:43:58 GMT

Give me the variable description

Re: variable help

Wed, 27 Mar 2013 16:48:47 GMT

Hi,

this is my variable. it is made up of other varibales so i will lest them all..

LET vDaysInRangeTMP = '=networkdays(vMinEventDate,vMaxEventDate,$(vBankHolidays))';

vMaxEventDate and v MinEventDate are just made up of the min and max of [Event Date]

and the vBankHolidays is made up of..

concat(distinct num(HolidayDate),',') AS PublicHol

I hope this is clear

Re: variable help

Wed, 27 Mar 2013 19:05:09 GMT

Does anyone have any ideas?