topic Re: How to use a variable in a calculated dimension with an IF statement in QlikView

How to use a variable in a calculated dimension with an IF statement

paul_ripley — Sat, 16 Nov 2024 02:13:44 GMT

Hello

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

Paul

Re: How to use a variable in a calculated dimension with an IF statement

JGMDataAnalysis — Mon, 14 Oct 2019 16:31:24 GMT

You can solve this at load time (script)...

SET vQuoted = 02502028, 22001206; Test: NOCONCATENATE LOAD *, If(Index('$(vQuoted)', Portfolio), 'Quoted', 'Unquoted') AS Dim INLINE [ Portfolio, 02502028 22001206 22001207 ];

Use Dim field (From Script). Otherwise, add calculated dimension (FRONTEND).

Re: How to use a variable in a calculated dimension with an IF statement

paul_ripley — Tue, 15 Oct 2019 09:25:51 GMT

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,

Thanks for your help