topic Re: How to create alternative filter? in QlikView

How to create alternative filter?

Wed, 25 Nov 2020 16:16:04 GMT

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:

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

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

Re: How to create alternative filter?

Kushal_Chawda — Fri, 29 Apr 2016 10:12:22 GMT

Create the list box expression

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:13:55 GMT

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!

Re: How to create alternative filter?

Anonymous — Fri, 29 Apr 2016 10:15:17 GMT

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:18:24 GMT

Hi,

This definitely a better solution than mine Thank you!

Cheers,

Niko

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:19:20 GMT

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:19:43 GMT

Try with list box expression,

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:28:26 GMT

Hi,

PFA,

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:29:36 GMT

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:33:45 GMT

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

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:34:13 GMT

This was already answered !

Re: How to create alternative filter?

Anonymous — Fri, 29 Apr 2016 10:34:35 GMT

Hi Niko,

You can add a calculated dimension and use the same expression than the one in the listbox

Just be aware of check the supress when value is null option to take out the rows that you don't want to display.

Regards,

-- Karla

Re: How to create alternative filter?

Fri, 29 Apr 2016 10:37:28 GMT

Yes, thank you !

Cheers,

Niko