topic products without movement in QlikView

products without movement

spividori — Wed, 25 Nov 2020 14:26:35 GMT

Hi.

In my app when selecting one or two dates I need to identify the IDs that no had movement.

Regards.

Re: products without movement

Chanty4u — Wed, 25 Nov 2020 15:11:21 GMT

what is the value for no movement ?

Re: products without movement

spividori — Wed, 25 Nov 2020 15:33:45 GMT

Hi.

Thanks for reply.

In the example if I select 12/08/2020, 8 IDs had movements in the CANT field and the others did not.
I need to identify those that did not have, that is, the remaining 1030 IDs.

Attached reference image.

I hope you understand me, my English is poor.

Regards.

Re: products without movement

Kushal_Chawda — Wed, 25 Nov 2020 16:56:41 GMT

@spividori see the attached

Re: products without movement

spividori — Wed, 25 Nov 2020 19:43:11 GMT

Thanks a lot. It works perfect!.
Several times I tried to solve this issue but could never get response:

https://community.qlik.com/t5/New-to-QlikView/count-without-movements/m-p/1764000?search-action-id=104897704470&search-result-uid=1764000

https://community.qlik.com/t5/QlikView-App-Development/Items-without-movement/m-p/236726?search-action-id=104897704470&search-result-uid=236726

Regards.