topic Re: Need help on expression for backlog tickets in QlikView

Need help on expression for backlog tickets

Tue, 13 Jan 2015 06:47:12 GMT

Hi Friends,

I need to show the total tickets pending for day-1.

if I give below expression ill get overall tickets pending till now and I wont change when we select date,month.

=count(DISTINCT{$<[Service Module]={'INCIDENT MANAGEMENT'},CallStatus={'PENDING'},Call_Date={"<=$(=((vToday)))"},[Call_Day of Month]=,Call_Month=,Call_Year=>} Id)

I need help to get total pending tickets for today-1 day(till yesterday) and also it should change according to selection of date,month. please help.

Thanks in Advance

Re: Need help on expression for backlog tickets

arulsettu — Tue, 13 Jan 2015 06:57:41 GMT

try this

=count(DISTINCT{$<[Service Module]={'INCIDENT MANAGEMENT'},CallStatus={'PENDING'},Call_Date={"<=$(=((vToday)-1))"},[Call_Day of Month]=,Call_Month=,Call_Year=>} Id)

Re: Need help on expression for backlog tickets

Tue, 13 Jan 2015 09:13:51 GMT

Hi Rao

What is your variable vToday holding, bekos we can use it to date back one day, just like what Arul showed you., if this doesn't resolve your issue, please upload your data sample.

Re: Need help on expression for backlog tickets

Wed, 14 Jan 2015 06:06:05 GMT

Thanks Arul and Dlamini.. I will work on it and get back to you