Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
Creator III
Creator III

Wildmatch IF and 2 fields

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)

Labels (2)
1 Solution

Accepted Solutions
paul_ripley
Creator III
Creator III
Author

thanks but i ended up solving the issue 

Thanks for offering to help

View solution in original post

2 Replies
Taoufiq_Zarra

can you develop or share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
paul_ripley
Creator III
Creator III
Author

thanks but i ended up solving the issue 

Thanks for offering to help

View solution in original post