Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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