Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
For the confusion arise , I am doing a fresh query .
Please assist in getting the non user from the sample model
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,