Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Create the list box expression
= aggr(if(match(Dimension,'A','C'),Dimension),Dimension)
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!
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
Hi,
This definitely a better solution than mine Thank you!
Cheers,
Niko
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
Try with list box expression,
=if(not wildmatch(part,'B'),part)
Hi,
PFA,
> apply same statement under "Add calculated dimension" & Check suppress when value is null(CheckBox under it).
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
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