Forum Discussion
display only items with no data
I have to direct query tables. The are joined in data modeling section on full name. So, in the above diagram, tb1 shows all the names that are entered in to sql server table. Tb2 shows a result if these people are currently employeed in the company. In the above table, it show people who are not currently employeed as well as who are currently employeed. The blank rows in tb2 are the one who are not currently employeed.
I want to know if there is a way to display only people who have blank rows in tb2. In other words show only people who are not currently employeed in the company?
thank you
2 Replies
Hi rschaudhr,
You can set the values in the Visual Filter. Unselect all the values and choose only to show blank fields. That should do it.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous ForecastsI tried that. If I filter out any values tb2, all it does is return the full list from tb1.
