Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Grouping counts by date

Hi,

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

Table1:

invitation_id,

client_id,

batch_id,

campaign_id,

language_id,

sent,

date_created

from table1:

Table2:

invitation_id,

track_type,

date_created

from table2:

Table3:

invitation_id,

bounce,

unsubscribe,

date_created

from table3:

Table4:

id,

track_type

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

4 Replies
neha_shirsath
Valued Contributor

Re: Grouping counts by date

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.

berryandcherry6
Contributor II

Re: Grouping counts by date

Hi neha,

i have attached sample app. Please look into it.

neha_shirsath
Valued Contributor

Re: Grouping counts by date

Hi,

Attachment missing. Can you please attach it again.

berryandcherry6
Contributor II

Re: Grouping counts by date

Please find attached app

Community Browser