Count of Min(Date) in line graph is not working in Qliksense

[berryandcherry6]

Hi,

i have table with below fields,

LOAD `invitation_id`,

    `client_id`,

    `batch_meta_data_id`,

    first_email_send_date, // timestamp

    date(floor(first_email_send_date),'MM-DD-YYYY') as formatted_send_date,

   opened ;

from INVITATION table;

so to get counts of opens for particular batch_meta_data_id for min(first_email_send_date). i am using like below

tried these expressions:

count({$<batch_meta_data_id={'96'}, formatted_send_date= {"=$(=Min(formatted_send_date))"},opened = {'1'}>}distinct invitation_id)

count({$<batch_meta_data_id={'96'}, formatted_send_date= {"=$(=Date(Min(formatted_send_date),'MM-DD-YYYY'))"},opened = {'1'}>}distinct invitation_id)

Dimension: Hour(first_opened_date)

But i am getting Zero.

What am i doing wrong. Please help me.

[MK_QSL]

What is the dimension you are using?

[MK_QSL]

or try this

=FirstSortedValue({<batch_meta_data_id={'96'}>}

Aggr(Count({<batch_meta_data_id={'96'}>}Distinct invitation_id),batch_meta_data_id,formatted_send_date),

-Aggr(formatted_send_date, batch_meta_data_id,formatted_send_date)

)

[berryandcherry6]

Dimension: Hour(first_opened_date)

[berryandcherry6]

Hi mrkachhiaimp

i followed your code but it still shows wrong values for min date.

for

batch_meta_data_id = 96, total open counts  = 1048

batch_meta_data_id = 97, total open counts  = 357

I am attaching sample app.

[MK_QSL]

What is the output you are looking for?

[berryandcherry6]

I am looking for a hourly open stats for first day of the batch in line graph.

[MK_QSL]

I am talking about output.. Not description..

give me number for particular case, so that I can try to match that.

[berryandcherry6]

batch_meta_data_id = 96, opens on 3rd hour = 85. opens on 4th hour = 109. so like this totally 1048 opens on first day(i.e 10/31/2017).

[MK_QSL]

I can see for 96, we have min formatted date is 10-31-2017..

which is OK..

but as per first_email_send_date the time is all 3am..

so how come 4th hour is coming here?