Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello;
I am very new to qlik sense and I think that this should be pretty straight forward,
I would like to use an expression if possible to create a combination key that I can then use to associate tables.
I have field 1 Invoice number and field 2 Vendor number and I would like to add a a filed that would be vendor number_invoice number as vendorinvoicekey.
I can see how this could be done from a load script but I am struggling with the expression. Is this possible
Thank you in advance
Hi Ian,
Check this video out: - let me know if this is similar or what you need. - It just uses a simple concatenation.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
[Invoice number] & [Vendor number] as vendorinvoicekey in your script