Can I define a label for certain filter values

Guest shared this question 4 years ago
Answered

Hello,

Is it possible to use the custom query option in a filter to define some sort of label to show in the filter. So I want to filter on a number but show a label. This label is in a different table. I can easily create a query with gives the number and the label (description) but the measure table has the number in it and not the label.

I thought I read somewhere that this is possible but I get an error that the query should result in a single field.

/40ce297fe0d52e15a03401f5464072d1

Maybe the names should be something specific.

I tried finding the article or forum post where I read that this was possible so now I am unsure if it is.

Please let me know.

Regards,

JeRoen

Replies (2)

photo
1

Hi There

I have done something similar to what you require by using Reference Codes

in YF 8 you can refresh Reference Codes with a SQL Query that returns the Code, the Description (Label) and if required the Sort Order

You can then use that Reference Code in your Filter Group in the View to Select using the Code but Display the Description (label) and if required have a specific Sort Order

photo
1

Hello,

Thanks. We managed to get it working by using reference codes.

Regards,

JeRoen

Leave a Comment
 
Attach a file