-
1. Re: Filter with Null Values
Sankarmagesh Rajan Dec 15, 2016 3:02 AM (in response to Govind Ramchetty)hi Create set with using Govind,Raj,Raman and drag this set into filter and select in.
now null will not show in filter.
Thanks
sankar
-
2. Re: Filter with Null Values
Govind Ramchetty Dec 15, 2016 3:25 AM (in response to Sankarmagesh Rajan) -
3. Re: Filter with Null Values
anand.hariyani Dec 15, 2016 3:31 AM (in response to Govind Ramchetty)Hello,
Please send your workbook.
Thanks,
Aanand
-
4. Re: Filter with Null Values
Sankarmagesh Rajan Dec 15, 2016 4:02 AM (in response to Govind Ramchetty)hi
Right click OEM field in dimension window and create set. select needed fields only. Drag that set into filter shelf and select in.
Thanks
sankar
-
5. Re: Filter with Null Values
DIVYA TIKKISETTI Dec 27, 2016 1:16 AM (in response to Sankarmagesh Rajan)Hi SankarMagesh ,
To some extent creation of set(Govind,Raj,Raman) may solve this issue.But what if the filter filed value gets few more names other than Govind,Raj,Raman .
They doesnt get automatically synced up with the IN Members of SET.
Is there any alternative sol for this?
-
6. Re: Filter with Null Values
Sankarmagesh Rajan Dec 27, 2016 2:21 AM (in response to DIVYA TIKKISETTI)Hi divya,
Good question.
We can go with other way.
Steps1:
1.Create duplicate of your name dimension.
2. Drag this new dim into filter and select null then exclude it.
Step2.
1.Drag original name into filter and then show quick filer.
2.Select customize option to check more or fewer option.
3.Select Fewer Values in filter top right side.
thanks
sankar
-
7. Re: Filter with Null Values
keerthana kumar Dec 27, 2016 3:28 AM (in response to Govind Ramchetty)Hi Govind,
1. Create duplicate of "Filter value" (ur column).
2. Place the duplicate in filter .
3. Exclude Null
4. Right click add to context
5. Now add the original column[Filter Value]... then from filter options "choose only Relevant values"