Previous day trend values

[Rajesh]

Hi All,

The required result has achieved using sql server with attached query and output.

Main purpose of the report is to:  

List the workflow names which runs >20 mins (this is i am getting)

but Same workflow names how much time took in previous days.

Trying to achieve same in Qlik But not able to achieve.

Able to get todays data in qlik as same out put as SQL, but not previous days.

(Right now todays data not available in attached app-assume yesterday data as Todays data)

Can any one suggest the solution.

Thanks

Rajesh

[Rajesh]

Please find attached app

Regards

Rajesh

[kaanerisen · Accepted solution]

Hi Rajesh,

You can do that by using set analysis with p() function.

http://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...

Please check the attached qvf

=Sum(
	  {<
       	Date={"$(=Date(Today()-2,'MM/DD/YYYY'))"},
	   	WORKFLOW_ID=p({<Duration={">20"},Date={"$(=Date(Today()-1,'MM/DD/YYYY'))"}>} WORKFLOW_ID),
	   	INSTANCE_ID=p({<Duration={">20"},Date={"$(=Date(Today()-1,'MM/DD/YYYY'))"}>} INSTANCE_ID)
      >} 
    Duration)

Hope it helps,

[Rajesh]

Thank you very much Kaanerisen,

The values are coming as expected with your expression.

Regards

Rajesh.