Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruan_Sasse
Contributor II
Contributor II

Issue with filters hiding new fields in Qlik table

Hello Qlik Community,

I'm facing an issue with field visibility in a Qlik table. Every time I add a new field, it seems to disappear from the view, and I've discovered that this is due to certain user-created filters.

Even after clearing the filters applied by users, the new fields remain hidden in the table. However, when no filters are applied, the fields appear as expected.

Has anyone encountered a solution to this type of problem? How can I ensure that new fields are displayed regardless of the filters applied by users?

I appreciate any help or guidance you can offer.

Thank you!

Labels (1)
1 Solution

Accepted Solutions
RafaelBarrios
Partner - Specialist
Partner - Specialist

Hello again @Ruan_Sasse 

its hard to say without the datamodel, but as far as i can see the market its not selecting 54. its selecting1,3,5,6,13,14,18,20

also, not sure about the version your are usign, but for self service table you can try the one included in extesion bundle

RafaelBarrios_0-1711010605529.png

here, yan can configure available fields, and users can select which to show/hide even if its not in edit mode

RafaelBarrios_1-1711011252772.png

RafaelBarrios_3-1711011326354.png

 

one big "BUT" be aware that same as variables, bookmarks dont saves/sets this table selection or values in variables.

Espero te sea de ayuda.

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 

 

View solution in original post

4 Replies
RafaelBarrios
Partner - Specialist
Partner - Specialist

Hi  @Ruan_Sasse 

it would be very helpfull if you paste script, data model and an example

when you talk about "hidden" fields two things comes to my mind

in script:

"SET HidePrefix ='_'" that will hide any field that starts with _ character
in section access

"OMIT" to hide fields for some users

but i dont thing it is your problem.

 

Keep Commenting

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁

 

Ruan_Sasse
Contributor II
Contributor II
Author

 

 

I have a table that is assembled through ad hoc fields

Ruan_Sasse_0-1710943601291.png

 

That's the condition used to appear in the table

Ruan_Sasse_1-1710943774046.png

 

 

 

 

 

This is one of the markers that causes the issue

Ruan_Sasse_2-1710943866356.png

As you can see, after selecting the marker, clearing the filters, and selecting the field again, it doesn't appear in the table

 

Ruan_Sasse_3-1710944130814.png

 

 

RafaelBarrios
Partner - Specialist
Partner - Specialist

Hello again @Ruan_Sasse 

its hard to say without the datamodel, but as far as i can see the market its not selecting 54. its selecting1,3,5,6,13,14,18,20

also, not sure about the version your are usign, but for self service table you can try the one included in extesion bundle

RafaelBarrios_0-1711010605529.png

here, yan can configure available fields, and users can select which to show/hide even if its not in edit mode

RafaelBarrios_1-1711011252772.png

RafaelBarrios_3-1711011326354.png

 

one big "BUT" be aware that same as variables, bookmarks dont saves/sets this table selection or values in variables.

Espero te sea de ayuda.

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 

 

Ruan_Sasse
Contributor II
Contributor II
Author

Obrigado pela ajuda!