Please assist .

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

Hi All ,

For the confusion arise , I am doing a fresh query .

Both are same query.

In my Qlikview Model ,

I got a ProductListing Table where I got supplier and Dealer without date field .

Another table is the transaction table of Deal called temp_DealProductListing which got date_updated as date field.

For my report requirement :

All the dealer present in the "ProductListing " is Open User .

All the dealer present in the "temp_DealProductListing " is the User which is based on Year and Month .

The problem I am facing is to get the Non User based on Year and Month .

According to my requirement , The Non User should be Open User - User.

To show the dealer by selecting the filters Year and Month , The User are changing but the non user are not changing .

For eg,

Non User are Open User - User.

In Transactional Deal table , I have only got User with date field .

For Feb 2018 ,

Open User 15

User 7

Non User is 8

The user Can be determined By "temp_DealProductListing " count (dealer)

The problem is with non user

For Feb 2018 ,

I got 8 non user , but as I got 7 non user marked a 0 . thus the name is reflecting for only for 7 user.

"Selfords Select" should also reflect as non user for Feb Month.

My requirement is 1-2 = 3

I have show the dealer name .

Please suggest .

Sample Model attached.

Thanks,

topic Please assist . in QlikView