Discussion board where members can get started with Qlik Sense.
i have a requirement where i need to get counts for sent,delievred,opens,clicks, bounce, unsubscribe each date in Table.
Days opens clicks delievred sent
28/10/2017 3 3 5 5
29/10/2017 1 0 6 8
30/10/2017 13 10 22 34
01/12/2017 2 1 4 4
02/12/2017 4 3 6 7
03/12/2017 6 5 6 6
Here dimension rows increases day by day because it is dynamic takes every day date.
i have 3 tables with fields and different datecreated
from table4;// track_type=1 is opened,track_type=2 is clicked
here for each date i want to show counts by date_created and campaign_id.
i have posted sample app below in discussion.PLease refer
How could i do this? Please help me on this
Can you send some sample data?
Or probably you can force concatenate all 4 tables and create master calendar.
Or depends on requirement you can create link table with common fields and date and link this date to your Master Calendar.
i have attached sample app. Please look into it.
Attachment missing. Can you please attach it again.
Please find attached app