Hide expression in the filter pane

[shirleyk]

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!

[miguelbraga]

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]

Thanks for the quick reply.

Here is the screenshot for your reference. Thanks.

[rubenmarin · Accepted solution]

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]

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

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

[miguelbraga]

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]

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

[miguelbraga]

If you found this helpful please mark it