Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've looked for a solution to my problem below and couldn't find an answer in the discussions:
I have 2 tables:
Table A: User By Campaign By Campaign Date:
User | Campaign | Campaign Date |
a@mail.com | A | 01/01/2019 |
b@mail.com | A | 01/01/2019 |
c@mail.com | B | 01/03/2019 |
d@mail.com | B | 01/03/2019 |
Table B: Spend By User By Date:
Date | User | Spend |
01/01/2019 | a@mail.com | 200 |
01/01/2019 | d@mail.com | 100 |
01/02/2019 | c@mail.com | 300 |
01/02/2019 | b@mail.com | 400 |
My objective is to have the Campaign from the user input in the dashboard (using a filter for example) and show the sum of spend for the impacted users for that given campaign by day. My idea was to do the following:
Is it possible to do that in a dashboard? If so how should I proceed?
Any help is very welcome!
Thanks!
Hi Vegar, thanks for the quick response.
I'm a beginner on the Qlik syntax so excuse me for the basic questioning. Your suggestion is to included that expression as a measure?
Just to clarify: I need to retrieve the list of users impacted for a given campaign from Table A, before using them to check their spend in Table B, so just filtering by Campaign Date won't work.
Thanks in advance.