topic Data Selection from Today or Yesterday in QlikView

Data Selection from Today or Yesterday

nwilliams — Tue, 10 Jun 2014 09:10:02 GMT

Hi,

I'm creating some text boxes to show high level metrics from Today & Yesterday. My data set has around 4 years of data in it. I have created 2 variables for Today & Yesterday:

LET c_Today = Date(Today());
LET c_Yesterday = Date(Today() -1);

My text box has the following expression in it:

               =Count(DISTINCT{
              <QueueInteractionsView.c_QueueGroup={'IT Service Desk'},
               [QueueInteractionsView.IBeginTime_Date]=c_Today,
               }>}QueueInteractionsView.IID)

It says "Expression OK" but the value '0' is returned. There is data in the DB for today, and the field 'QueueInteractionsView.IBeginTime_Date' is wrapped in 'Date' in the load script.

Any ideas why this is not working?

Re: Data Selection from Today or Yesterday

MK_QSL — Tue, 10 Jun 2014 09:13:14 GMT

=Count(DISTINCT{
              <QueueInteractionsView.c_QueueGroup={'IT Service Desk'},
               [QueueInteractionsView.IBeginTime_Date]={'$(c_Today)'},
               }>}QueueInteractionsView.IID)

=Count(DISTINCT{
              <QueueInteractionsView.c_QueueGroup={'IT Service Desk'},
               [QueueInteractionsView.IBeginTime_Date]={'>=$(c_Today)'},
               }>}QueueInteractionsView.IID)

Re: Data Selection from Today or Yesterday

PradeepReddy — Tue, 10 Jun 2014 09:25:12 GMT

If you want to showcase both today's and yesterday count in,

In Different text boxes,

=Count(DISTINCT{ <QueueInteractionsView.c_QueueGroup={'IT Service Desk'},
[QueueInteractionsView.IBeginTime_Date]={'$(c_Today)'}>}QueueInteractionsView.IID)

=Count(DISTINCT{ <QueueInteractionsView.c_QueueGroup={'IT Service Desk'},
[QueueInteractionsView.IBeginTime_Date]={'$(c_Yesterday )'}>}QueueInteractionsView.IID)

In Same text box,

=Count(DISTINCT{ <QueueInteractionsView.c_QueueGroup={'IT Service Desk'},
[QueueInteractionsView.IBeginTime_Date]={'>=$(c_Yesterday )'}>}QueueInteractionsView.IID)

Re: Data Selection from Today or Yesterday

nwilliams — Tue, 10 Jun 2014 11:46:19 GMT

Thanks for your help.

Re: Data Selection from Today or Yesterday

MK_QSL — Tue, 10 Jun 2014 11:47:46 GMT

Please close the thread by selecting appropriate answer