topic select all values? in QlikView

select all values?

qlikuser222 — Wed, 28 Dec 2016 20:11:33 GMT

Hi All,

I have table

ID:

Load

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

MK_QSL — Wed, 28 Dec 2016 20:12:25 GMT

What exactly you want to say ?

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

jayanttibhe — Wed, 28 Dec 2016 20:13:42 GMT

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 — Wed, 28 Dec 2016 20:16:21 GMT

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 — Wed, 28 Dec 2016 20:19:01 GMT

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 — Thu, 29 Dec 2016 05:54:19 GMT

Still Confusing

But, As i assume you may need this

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

RowNo

];

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