topic Re: Compare values from the same field for different months in QlikView

Compare values from the same field for different months

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

I have the following fields in my QV.

Load

Apps,

Users,

Month

from...

I need to compare values in the Users field for each month and show them.

For example, if I select Mar as my month, I need to the number of users that are present both in Mar and other months respectively (Common Users).

Re: Compare values from the same field for different months

Anil_Babu_Samineni — Mon, 08 Jan 2018 17:50:10 GMT

Perhaps this?

Count({<Month = P(Month), Users = P({<Month = {$(=Max(Month))}>} Users)>} Users)

Re: Compare values from the same field for different months

qlikwiz123 — Mon, 08 Jan 2018 18:06:38 GMT

Returning 0s

Re: Compare values from the same field for different months

Anil_Babu_Samineni — Mon, 08 Jan 2018 18:15:07 GMT

May be i misplaced wrong. Can you explain with data set?

Re: Compare values from the same field for different months

qlikwiz123 — Mon, 08 Jan 2018 18:27:59 GMT

Apps User Month

ABC A1 Jan

ABC A1 Feb

ABC B1 Feb

ABC B1 March

If I select Jan in my List box, the count of Users for Feb should be 1 and March 0 as only one user is present in Feb, which is also present in Jan and 0 users are present in March from Jan. Similarly, for all months, I need the same type of result, based on the selected month.

Re: Compare values from the same field for different months

qlikwiz123 — Mon, 08 Jan 2018 19:20:57 GMT

stalwar1‌

Any idea?

Re: Compare values from the same field for different months

sunny_talwar — Mon, 08 Jan 2018 19:27:09 GMT

May be this

Count(DISTINCT {<Month, User = p(User)>} Users)

Re: Compare values from the same field for different months

qlikwiz123 — Mon, 08 Jan 2018 19:47:38 GMT

This expression returns all the Users present for the selected month.

If I pick Mar, it should return the no. of Users present in

(Mar and Apr)

(Mar and May)

(Mar and Jun)

(Mar and Dec)

Similarly, if I pick Apr, it should present the no. of Users in

(Apr and May)

(Apr and Jun)

(Apr and Dec)

***Common Users present in the selected month and the respective following months

Re: Compare values from the same field for different months

sunny_talwar — Mon, 08 Jan 2018 19:49:12 GMT

Would you be able to share a sample so that we can take a look at it