Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qlikuser222
Contributor

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

Tags (2)
5 Replies
MVP
MVP

Re: select all values?

What exactly you want to say ?

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

jayanttibhe
Contributor III

Re: select all values?

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
Contributor

Re: select all values?

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
Contributor

Re: select all values?

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

Re: select all values?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)