topic Re: Previous day trend values in App Development

Previous day trend values

Rajesh — Tue, 09 Jul 2019 05:55:30 GMT

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

Re: Previous day trend values

Rajesh — Tue, 09 Jul 2019 06:03:10 GMT

Please find attached app

Regards

Rajesh

Re: Previous day trend values

kaanerisen — Tue, 09 Jul 2019 06:41:35 GMT

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/SetAnalysis/set-modifiers-implicit-field-value-definitions.htm

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,

Re: Previous day trend values

Rajesh — Tue, 09 Jul 2019 10:03:29 GMT

Thank you very much Kaanerisen,

The values are coming as expected with your expression.

Regards

Rajesh.