Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gurus,
I'm new into the QlikView world, so I need some help. I want to create into a straight table a new expression like this one
case when CR_COD_CURRENCY_SAP = 'EUR' then Act Price Material EUR
when CR_COD_CURRENCY_SAP = 'USD' then Act Price Material USD
when CR_COD_CURRENCY_SAP = 'LOCAL' then Act Price Material LOCAL
END
where CR_COD_CURRENCY_SAP is a dimension and Act Price Material EUR, Act Price Material USD, Act Price Material LOCAL are variables.
How can I translate this into QV language?
Thank you in advance,
Cristina
Maybe like
=pick(
match(CR_COD_CURRENCY_SAP, 'EUR', 'USD', 'LOCAL'),
ActPriceMaterialEUR,
ActPriceMaterialUSD,
ActPriceMaterialLOCAL
)
Thank you for your quickly reply, but the syntax is not correct. I modified it like this in order to get Expression OK:
pick(
match(CR_COD_CURRENCY_SAP, 'EUR', 'USD', 'LOCAL'),
$(Act Price Material EUR),
$(Act Price Material USD),
$(Act Price Material Local))
but it doesn't work, the column is empty.