I have a filter pane which has Date values and this filters a table which shows the Users present at a location on that day.
But, I want to show those users who were NOT present on that day. How is this possible using Qlik Sense?
Click on the name of the filter and the menu will appear.
You will see ... (3 dots)
Click on that and choose Select Excluded.
This should then pick everything in the filter that was not already chosen. So if you had Mary picked and Tom and Steve not picked. When you do this you will have Tom and Steve picked and not Mary.
Let me know if that is what you were looking for.
That is not exactly what I was looking for. Suppose, I have a filter 'Month' with values Jan, Feb, March and a straight table with a list of users who use a particular website, say X, Y, Z.
So in Jan if X used the website and Y and Z did not, upon selecting Jan, I want only Y and Z to show up in my table.
The solution you mentioned, selects Feb, March instead of Jan, which is not I want.
Please let me know if there is a solution to the above problem.
Thanks for the help!
How to I hide the contents of the column? It is returning strange values. Also, how should I do the above process for multiple filter panes?
Appreciate your help!
I changed little bit the QVF file for better visualization in PIVOT TABLE
My new sheet:
FILTER PANE :
If you select date : 07.02.2016 (MM.DD.YYYY) ( user:CA)
PIVOT TABLE :
the users and location not in the date 07.02.2016 can be seen in the pivot table
Seems like this is working for one filter. How can I do this for multiple filters? Say Date, Month, Hour etc.?
Also, I want to hide one of the columns. Is it possible?
Thank you so much for the help!