Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator III
Creator III

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
Highlighted
MVP
MVP

Create the list box expression

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

Highlighted
Not applicable

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!

Highlighted
Creator III
Creator III

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

Highlighted
Not applicable

Hi,

This definitely a better solution than mine Thank you!

Cheers,

Niko

Highlighted
Not applicable

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

Highlighted
Not applicable

Try with list box expression,

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

Highlighted
Not applicable

Hi,

PFA,

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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