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: 
Carson
Contributor
Contributor

Remove possible values from table loaded from Oracle DB

Im new to Qlik Sense so pardon me for how unclear this question may be. 

Im loading in a table and the possible values are for example "a", "b","c","d", and "e". Suppose my dataset for this specific application only applies to the values a and b. I have a radio selection that allows a user to select a, b, c, d, or e (based on possible values from the table). I would like the user to only be able to view a and b in that radio selection box. Is this something I can change in the data load editor? Here is an example of what my code looks like:

 

[REF_FRUITS]:

LOAD

[ID] AS [FRUITS_ID-ID],

[DISPLAY_NAME] AS [REF_FRUITS.DISPLAY_NAME],

[DESCRIPTION] AS [REF_FRUITS.DISCRIPTION];

SELECT "ID",

"DISPLAY_NAME",

"DESCRIPTION"

FROM "GROCERY_STORE"."REF_FRUITS"; 

Labels (3)
0 Replies