Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

select all values?

Hi All,

I have table

ID:

Load

1,

2,

3,

4

from...

I need a function on front end where is shows all values on table ID.

Ex: to show particular object i need this function in the conditional layout..if(get possible values(Filename(Numbers))=OS(USER).

can anyone please provide me the correct function.

Thanks

5 Replies
MK_QSL
MVP
MVP

What exactly you want to say ?

if(get possible values(Filename(Numbers))=OS(USER)

jayanttibhe
Creator III
Creator III

Concat(ID,',')

Try it.  (I am considering your table has ID columns and you are interested to show all the values in that Column)

Thanks

Jayant

qlikuser222
Creator
Creator
Author

hi,

Object should appear to users whose ID is in the ID field.

if ID 1 logs in his ouster() shows 1 (for example) so i want to conditionally hide the object based on ID = ouster(),

when user who's is not part of ID logs in he cannot see that object.

Thanks

qlikuser222
Creator
Creator
Author

Hi,

below is my requirement

Object should appear to users whose ID is in the ID field.

if ID 1 logs in his ouster() shows 1 (for example) so i want to conditionally hide the object based on ID = ouster(),

when user who's is not part of ID logs in he cannot see that object.

Thanks

Anil_Babu_Samineni

Still Confusing

But, As i assume you may need this

Load *, OSUSER() as ID,Subfield(ID, '/',1) as IDUname Inline [

RowNo

1

2

3

4

];

Then create one variable like vshow = 1

Then use this condition from Layout Tab of conditional enable by using this

If(vshow=1, 1, 0)

Or else please explain more

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful