topic Re: Calculating difference between actual and month before in QlikView

Calculating difference between actual and month before

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the Problem, that I want to see a development in a diagram. Is it possible to Show the monthly development in column 3 ("abgeschlossen")? Actually, in April 2017 there were 61 closed projects and I

1) only see the difference one month later which is bad

2) only see a total number where I want to see a calculated figure...

Any ideas?

Michael

Re: Calculating difference between actual and month before

sibusiso90 — Tue, 23 May 2017 13:28:52 GMT

There is not enough information as we are not aware as to what is breaking, from your script on the table to your load script

Re: Calculating difference between actual and month before

Tue, 23 May 2017 13:49:11 GMT

The data is correct, I just want to know if it is possible to subtract last month figures from actual.

Attached pls find the file.

Re: Calculating difference between actual and month before

Frank_Hartmann — Tue, 23 May 2017 15:25:20 GMT

try this:

count({<Status={"abgeschlossen"}>} DISTINCT [Projektnr. / Project No.]) -

below(count({<Status={"abgeschlossen"}>} DISTINCT [Projektnr. / Project No.]))

Re: Calculating difference between actual and month before

Tue, 23 May 2017 15:42:14 GMT

I actually tried it a bit differently:

(count({<Status={"abgeschlossen"}>} DISTINCT [Projektnr. / Project No.]) -

above(count({<Status={"abgeschlossen"}>} DISTINCT [Projektnr. / Project No.])))*-1

Thank you very much!