Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

Using aliases in a filter pane

Hi,

I'm using a filter pane to filter some data by severity. I've set up a dimension = EventSeverityId. It takes values from 1 to 4, and it works as expected.

My only concern is that I'd prefer the user to see (Level 1, Level 2, Level 3, Other) instead of the plain numbers (1, 2, 3, 4) in the filter pane selection. Is it possible to use something like aliases? In general I'm interested in differentiate what Qlik uses internally  to filter from what the user see on the screen.

Thanks much,

Juan

1 Solution

Accepted Solutions
poppypearce
Creator
Creator

Hi juan,

Try using expression in filter plane as 'Level' & fieldname.

View solution in original post

3 Replies
Anonymous
Not applicable

Have a look at the Qlik Dual() function Dual - script and chart function ‒ Qlik Sense

This allows a field to have both a numeric and a text value with which you should be able to let your users select against the text value as opposed to the plain numeric value.

morenoju
Partner - Specialist
Partner - Specialist
Author

Hi Bill,

Thanks for the answer. That involves changing the load script. Any chances of doing something to the actual configuration of the filter pane so the load script does not have to be changed?

Thanks!

poppypearce
Creator
Creator

Hi juan,

Try using expression in filter plane as 'Level' & fieldname.