topic Re: set with variable in QlikView

set with variable

Chanty4u — Sat, 16 Nov 2024 04:40:20 GMT

Hi all,

i have variable like below im using in this in set analysis but its showing error in expression..

vCurHalf_Year = chr(39)&concat(Half_Year,chr(39)&','&chr(39))& chr(39)

textbox expression: =sum({$<Half_Year={(=$(vCurHalf_Year)},Type={'Forecast_SR','Forecast_SSR'}>}Service_Amount)

what might be the issue?

Thanks

sunny_talwar — Thu, 24 Jan 2019 14:58:35 GMT

May be try one of these

=Sum({$<Half_Year = {$(=$(vCurHalf_Year))},Type = {'Forecast_SR', 'Forecast_SSR'}>} Service_Amount)

Or this

=Sum({$<Half_Year = {$(vCurHalf_Year)},Type = {'Forecast_SR', 'Forecast_SSR'}>} Service_Amount)

Chanty4u — Thu, 24 Jan 2019 15:04:19 GMT

thanks sunny.. 1st one is working .. 2nd one showing expression error.