Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
Specialist III
Specialist III

can you supply data?  hard to guess