topic Re: Difference between date in QlikView

Difference between date

canmarroig — Tue, 10 Nov 2015 10:51:08 GMT

Hi, i need to represent time how many tickets have been solved the last month, within x days (a variable called vDatSet) from support request and time to solve problem.

I've tried to :

if((date([Solution])-date([OpenTicket]))<=$(vDaySet),count(distinct ID_Ticket))

but I dont' understand how set date on last month and how match set analysis and if condition.

Help me pls.

Can

Re: Difference between date

m_woolf — Tue, 10 Nov 2015 12:56:08 GMT

Try:

count(distinct if((date([Solution])-date([OpenTicket]))<=$(vDaySet),ID_Ticket))

Re: Difference between date

jonathandienst — Tue, 10 Nov 2015 12:59:59 GMT

Assuming Solution and OpenTicket are true (numeric) date fields and vDaySet is a number, then this should work:

=Count(If(Solution - OpenTicket <= vDaySet, Distinct ID_Ticket))

Re: Difference between date

Mark_Little — Tue, 10 Nov 2015 13:00:32 GMT

Hi,

Another possibly approach would be to add a days to resolve field in the script.

then Count({<DaystoResolve={'<=$(vDaySet)'}>}Distinct ID_Ticket)

Mark

Re: Difference between date

jonathandienst — Tue, 10 Nov 2015 13:04:52 GMT

If that does not work, it may be that your "date" fields are actually strings and/or mat contain a date component.

Sum(If()) expressions can perform poorly on large data sets, so you may want to create a derived variable, something like this:

LOAD

...

Solution - OpenTicket As Offset,

Solution,

OpenTicket,

...

Then you can use a set expression (which should perform much better):

Count{<Offset = {"<=$(vDaySet)"}>} Distinct ID_Ticket)

For more detailed help, please upload a representative sample qvw file.