Fancy set analysis or model rework

sibrulotte — Fri, 19 Feb 2021 17:01:50 GMT

Hi,

have a look at my data model in attached.

It was mainly done to show basic income analysis through "Transactions" and a calender.

Every transaction is done for an account, that is related to a person. The person identifier is Épargnants.NEP.

I linked that to a new table: Envois.

That table is basically a list of communications (emails) we sent out, and persons we sent it to, and WHEN that email was sent.

Ex:

Épargnants.NEP	Nom_envois	Date_envois
1110025584	We_miss_you	2020-10-01
1110035846	We_miss_you	2020-10-01
1110025584	Let's_have_a_drink	2020-11-01

So I'm looking for a way to show transactions for a person, but only if the date of the transaction follows the date of the communication ("envois").

I'm planning on having selections done for the "Nom_envois", and showing transactions in my graph.

Do I need to rework my model or should I try a set analysis to Show transactions with a date > Date_envois? If I do that and I have more than 1 selection done, thus maybe 2 "date_envois", that doesn't work anymore...

I'm puzzled.

Re: Fancy set analysis or model rework

edwin — Mon, 22 Feb 2021 18:50:59 GMT

can you supply data? hard to guess

topic Fancy set analysis or model rework in QlikView

Fancy set analysis or model rework

Re: Fancy set analysis or model rework