Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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