Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shirleyk
New Contributor II

Hide expression in the filter pane

I am using Qlik Sense and i would like to have a filter pane which display the Name of a female only.

In the expression of the filter pane, i use the expression if (Gender = 'F', Name). It works well and only female's name is displayed now.

However, when user selected one of the name in the filter pane, the whole expression rather than the selected field - Name appeared in the top black selection bar. It will make user confused about what they have selected.

May i know if there's any way that i can hide the expression and display the field name instead? Thanks!

1 Solution

Accepted Solutions

Re: Hide expression in the filter pane

Hi Shirley, you can try with:

Aggr(Only({1<Gender={'F'}>} Name, Name))

It will show a null value for the Names<>'F' so you might want to check the 'supress null values' on the dimension

7 Replies
miguelbraga
Valued Contributor III

Re: Hide expression in the filter pane

Hey there,

Share with us a screenshot of your selection. This way we'll evaluate what is the best solution for you to implement so that your final user won't be confused.

In advance I'll tell you that when you make selections in Qlik Sense it will always appear in the top black selection bar. If don't have a list box full expand, but rather in a one line, a user won't see what is selected after the actual selection.

Hope this information is relevant for you.

Regards,

MB

shirleyk
New Contributor II

Re: Hide expression in the filter pane

Thanks for the quick reply.

Here is the screenshot for your reference. Thanks.Screencapture.png

Re: Hide expression in the filter pane

Hi Shirley, you can try with:

Aggr(Only({1<Gender={'F'}>} Name, Name))

It will show a null value for the Names<>'F' so you might want to check the 'supress null values' on the dimension

shirleyk
New Contributor II

Re: Hide expression in the filter pane

Thanks so much, i can get it done by the following expression.

Aggr(Only({1<Gender={'X'}>} Name), Name)

miguelbraga
Valued Contributor III

Re: Hide expression in the filter pane

I think it's possible if you create Name field in Data Load Editor with the expression you've marked as the correct one like this:

Aggr(Only({1<Gender={'F'}>} Name, Name)) as Name,

This way you can add this Field into your sheet and only show Name in Listbox and in the selection

Hope you find this helpful.

Regards,

MB

shirleyk
New Contributor II

Re: Hide expression in the filter pane

Good suggestion! I will try it then. Many thanks.

miguelbraga
Valued Contributor III

Re: Hide expression in the filter pane

If you found this helpful please mark it

Community Browser