How to create alternative filter?

[#1]

Hello!

Is there a way to create a filter that shows only some values, without deleting any of the data from the table. The data is needed, but I need a filter that does not show all the values.

Like if I had a dimension values with I could filter:

A

B

C

But I would like to user have only chance to filter with these:

A

C

And the list is of course with ~100 of values.

There is a workbook attached also if someone want's to play around.

Cheers,

Niko

[Kushal_Chawda]

Create the list box expression

= aggr(if(match(Dimension,'A','C'),Dimension),Dimension)

[#3]

Well one solution obviously seems to be is to create an alternative table completely differently:

abc_filter:

LOAD * Inline

[

linkingid, FilterValue

A, A

C, C

];

And then only use the FilterValue as a filtering dimension.

Well, if any other suggestions I am all ear!

[Anonymous · Accepted solution]

Hi Niko,

In the listbox properties go to General -> Field, choose expression and enter something like:

=if(match(part,'A','C') > 0, part)

To display only the options that you want.

Hope it helps.

-- Karla

[#5]

Hi,

This definitely a better solution than mine Thank you!

Cheers,

Niko

[#6]

Hi,

Thank you! That was almost what I was searching.

There was a bit problem with this one: When selecting a value from the list, it hides the other values from the list and did not grey them out.

Cheers,

Niko

[#7]

Try with list box expression,

=if(not wildmatch(part,'B'),part)

[#8]

Hi,

PFA,

> apply same statement under "Add calculated dimension" & Check suppress when value is null(CheckBox under it).

[#9]

Is there a way to filter some values out from the table?

On the sample test.qvw there is a table test.

If i want to only show place values K1 and K2 on the table, is there a way to filter them without selections from the listbox?

Sorry for my stupid questions

Cheers,

Niko

[#10]

Actually this answered to my other question that I just made here

Just did a little modification, used wildmatch for the values I wanted to show.

Thank you!

Cheers,

Niko