Open date and close date issue - Qlik Community

kamalqlik · ‎2012-03-15

Hi Friends,

I am hoping a reply from you genius guys out there.

I have two Excel

1>Date excel--It Contain the Date with different timestamp with only one field.

2>Ticket excel-- It contain the

[ATM ID],

[Open Date],

[Close Date],

Sr No.

What I require...................

I want that I have to plot a Pivot or stright which will show something like this..

Date will come here from the date excel sheet field as row

1/1/2012 3:59 1/1/2012 4:59 and so on

SrNo Open Date Close date

S1AC00311

In case the open date lie in the Date coming from date excel than it should give 1 else 0.

Same as in case of closed date.

I am attching the excel and the qvw.but I am not getting the results

regards

Kamal

chriscammers · ‎2012-03-15

Kamal,

I looked at your data and your application but I don't understand what you are trying to accomplish. Please try to explain further what you are trying to achieve.

Try to describe what you are trying to count and be specific about the conditions and relationships between the data you have provided.

Thanks

Chris