Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have one table with a list of all users using an app. Another dynamically generated column in a straight table that generates a list of users who have used the app in the recent past based on Date, Minute, Week, Hour etc.
I need to create another field that shows all the users who are NOT using that app even if they have access. I want to do something like ALL USERS - Users logged in = Users not logged in.
Also, I want to see these results based on the filters, i.e Date, Month, Hour etc.
How can I do this in Qlik Sense?
Please help!
Thanks,
Srijhari
Hi Srijhari, I think your logic is right, from all the user exclude those logged in. Can you share your dynamically generated columns to check how this can be applied?
Hi Ruben,
The list of users logged in looks something like this:
I want a fourth column which shows the users who are not using the app. I have a table with list of all users.
Thanks,
Srijhari
Maybe with:
=Concat(TOTAL{<UserNameField=e(UserNameField)>} UserNameField, ', ')
I have a lot of doubts, maybe with a sample I can help better. Are you aware that all users not using the app will be repeated for each row?
Hi Ruben,
Thanks for the help! I think the process is quite complicated. I should probably modify the data a little bit.
Appreciate your help!