Discussion Board for collaboration related to QlikView App Development.
I have a variable vQuoted. It contain the values '02502028','22001206'
I'd like to use a calculated dimension and have done the below. Portfolio is another dimension
The below gives an error
=if(portfolio = $(vQuoted),'Quoted','Unquoted')
I did also try the below which didnt give an error but it doesnt calculate the variables
=if(portfolio = vQuoted,'Quoted','Unquoted')
Can you please help
Thanks for your help
I dont really understand the inline thing but i did think the idea of doing in the script was good, so i created a new dimension and that worked
if(match(portfolio,'02502028', '22001206')>=1, 'Quoted','Unquoted') as portfolio_quoted,
View solution in original post
You can solve this at load time (script)...
SET vQuoted = 02502028, 22001206;
LOAD *, If(Index('$(vQuoted)', Portfolio), 'Quoted', 'Unquoted') AS Dim
Use Dim field (From Script). Otherwise, add calculated dimension (FRONTEND).