Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
sibrulotte
Creator III
Creator III

Fancy set analysis or model rework

Hi, 

have a look at my data model in attached.flex model.png

 

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.NEPNom_envoisDate_envois
1110025584We_miss_you2020-10-01
1110035846We_miss_you2020-10-01
1110025584Let's_have_a_drink2020-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.

Labels (1)
1 Reply
edwin
Master II
Master II

can you supply data?  hard to guess