Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create alternative filter?

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

12 Replies
Kushal_Chawda

Create the list box expression

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

Not applicable
Author

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
Not applicable
Author

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

Not applicable
Author

Hi,

This definitely a better solution than mine Thank you!

Cheers,

Niko

Not applicable
Author

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

Not applicable
Author

Try with list box expression,

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

Not applicable
Author

Hi,

PFA,

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

Not applicable
Author

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

Not applicable
Author

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