Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi fellow Qlik users,
I want to combine two fields in an expression: ''recipenumber'' and ''description'' which lie in different tables and are connected through a specific number (I have already =[recipenumber]&' '&[description], I want to fit it with an where function). I only want one description per recipenumber (see example below) preferably which contains "HF", otherwise an ohter available description.
How can I do this? How can I make an where function which returns one desired value? Do I have to script or can I do it with an expression?
Here are the screenshots. I hope this helps to fix the problem