List of values

random_user_3869 — Tue, 25 Jan 2022 11:11:34 GMT

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

Re: List of values

MarcoWedel — Tue, 25 Jan 2022 17:04:03 GMT

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

topic List of values in App Development

List of values

Re: List of values