List of values

[random_user_3869]

Hello,

I need to improve a qlik saas applciation targeting around sales representatives in a specific areas.

For this year sales rep are targeting around 5 products (for the sake of the example we will call them A, B,C,D,E

But those products may change or evolve (it could be more or less).

initially in the sales sheet there were many calculation 

SUM({<PRODUCT = {'A','B','C','D','E'}>}Total revenue)

But i create a variable in the script :

vL.Target2022 = 'A'&chr(39)& chr(44)&chr(39)&'B'&chr(39)&chr(44)&chr(39)&'C'&chr(39)&chr(44)&chr(39)&'D'&chr(39)&chr(44)&chr(39)&'E'

that way i can make the set analysis the following more easy to read.

But i would like to put the top product in an excel sheet/sharepoint and make it available for the sales rep so that if they want to add more product they can.

Can you help me.

Thank you

[MarcoWedel]

Hi, 

like you already suggested, the PRODUCT TargetGroup relation could be defined in an Excel source

added to your load script using

tabTargetGroups:
LOAD TargetGroup, 
     PRODUCT
FROM [TargetGroups.xlsx] (ooxml, embedded labels, table is Sheet1);

and changing your expression to simply

Sum({$<TargetGroup={'TargetGroup1'}>} Total revenue)

enabling your sales representatives to edit the relevant products outside of QlikView in the Excel document instead.

hope this helps

Marco