How to filter results dependant on multiple rules

[louise_atherton]

Hello everyone

Hoping you can help.  I am trying to only display the value in the column of my table depending on the picklists that have been selected.  For this example I only want to show values in the cell when colour 'Pink' has been selected and when they have purchased 'online'.  To make things even more complicated I also want to rename the results so it displays as 'magenta' rather than 'pink'.  If this criteria is not met I want the cell to be blank.  I've tried an IF statement with no luck as it seems to make reference to me using too many parameters. 

As always, any help is greatly appreciated.  

P.S. I have a limited view of Qlik sense as provided through a supplier so can only do things via the edit expression tool. 

Many thanks

Louise 

[kaushiknsolanki]

Hi @louise_atherton  Can you please provide sample data and help us understand what you need.