topic Re: COUNT NEW/REMOVED VALUES in QlikView

COUNT NEW/REMOVED VALUES

marikabi — Fri, 15 Nov 2024 23:27:19 GMT

Hello,

i'm trying to find a way of counting new values and removed values comparing 2 dates.

Given the below example, i would like to find a way of calculating that 1 shop was closed in Feb (shop C) and 1 shop was opened in Feb (shop F).

Any clue how to do this?

DATE	SHOPS
JAN	A
JAN	B
JAN	C
JAN	D
JAN	E
FEB	A
FEB	B
FEB	D
FEB	E
FEB	F

Re: COUNT NEW/REMOVED VALUES

chrismarlow — Mon, 14 Dec 2020 16:38:10 GMT

Hi,

You can use excluded function in set analysis to identify the rows you want to count, there is a bit of hard coding in here & not sure how you want to display your count, so this may be more of less useful;

Cheers,

Chris.

Re: COUNT NEW/REMOVED VALUES

marikabi — Mon, 14 Dec 2020 17:28:40 GMT

Thanks Chris, this looks amazing!

Will test it and check if the result is what i expect.

Wish you a nice rest of the day :)!