topic Re: set analysis '=' modifier in QlikView

set analysis '=' modifier

ilanbaruch — Sat, 16 Nov 2024 18:37:38 GMT

hi all,

in my model i have an table with the below expression :

sum({<Date={'$(vMaxInvDate)'},[Calendar.Month]=,[Calendar.Year]=,[Calendar.Quarter]=,HolidayFlag=,Holiday=>} quantity)

when user select year 2020 it retrieves the correct value regardless the selection of Month, Quarter ...

problem is when selected year is 2019\2018 and Month\ Quarter - calculation retrieves 0 unless unselect Month\Quarter

so the modifier '=' works only with current year

any ideas ??

advanced thanks

sunny_talwar — Mon, 18 May 2020 12:55:31 GMT

How do you define $(vMaxInvDate) variable? Is this an expression based variable or hard coded?

ilanbaruch — Mon, 18 May 2020 12:59:37 GMT

expression based :

=date(Max(max_inv_date))

sunny_talwar — Mon, 18 May 2020 13:44:43 GMT

May be you need to ignore selection in your year, month, quarter fields within this expression also? Can you try this

=Date(Max({1} max_inv_date))

ilanbaruch — Mon, 18 May 2020 14:37:30 GMT

Within the variable expression?

sunny_talwar — Mon, 18 May 2020 14:43:51 GMT

yes

ilanbaruch — Tue, 19 May 2020 07:52:47 GMT

thank you