topic Re: Customer specific expressions in QlikView

Customer specific expressions

jstensig — Thu, 02 Feb 2017 14:57:48 GMT

Hi,

Is it possible to have customer specific expressions and how do I make it work?

I have the following table - with a specific expression for each CustomerID

Best regards

Anonymous — Thu, 02 Feb 2017 15:18:27 GMT

Is it practical for you to add an extra field in the load-script that you set with something like

if( match(ItemGrp, '10', '13', '15'), '1',

if( match(ItemGrp, '40', '50', '51', '2',

if( match( ItemNo, '100', '101', '102', '3'

if( match( ItemNo, '220', '221', '4', 'unknown') ) ) ) as CustomerID

MarcoWedel — Thu, 02 Feb 2017 23:56:02 GMT

maybe helpful:

regards

Marco

jstensig — Fri, 03 Feb 2017 07:52:15 GMT

Hi Herbert

Over time the number of specific expressions will grow and I´m looking for an automated solution rather than manually maintaining the load script.

Anyway, your idea brought up some other ideas I will try out 🙂

Have a nice day

jstensig — Fri, 03 Feb 2017 07:55:36 GMT

Hi Marco

Thank you for posting - very interesting subject !

Kind regards