Wildmatch IF and 2 fields

paul_ripley — Sat, 16 Nov 2024 01:15:05 GMT

Hello

I have a table and it shows a list of portfolio values. I would like to do a calculated dimension as if the period is 201903 and the portfolio_text is 'Action' then I need to create a new portfolio name 'EFV stake'. I also need to have the portfolio_text for 'Amor' to be renamed for all periods to 'EFV stake'. I thought i would at least try the Action part but the below doesnt seem to work - can you help with what i am doing wrong

many thanks

Paul

=if( wildmatch(portfolio_text,'Action')
+
wildmatch(period,201903), 'EFV stake'

, portfolio_text)

Re: Wildmatch IF and 2 fields

Taoufiq_Zarra — Wed, 19 Feb 2020 10:33:44 GMT

can you develop or share a sample data ?

Re: Wildmatch IF and 2 fields

paul_ripley — Mon, 24 Feb 2020 14:36:33 GMT

thanks but i ended up solving the issue

Thanks for offering to help

topic Re: Wildmatch IF and 2 fields in QlikView

Wildmatch IF and 2 fields

Re: Wildmatch IF and 2 fields

Re: Wildmatch IF and 2 fields