st.table

[Anonymous]

Hi

I  Have  a list Box ,as follows (It is data island )

Test

1

2

And I had The straight table  with couple of expression and dimension

Their one expression like test =if(uname=osuser(),1,2)

Based Above  mentioned list box if i select  1  in it , then straight table should be filtered  with all  where test expression =1

Can anyone help to achieve this

[Anil_Babu_Samineni]

Does you mean you have field called uname like. Can you elaborate more with application and tell us if you sorting text as 1 which user you want to show. In my example, Seems abc, pqr

Load * Inline [

uname, test

abc, 1

xyz, 2

pqr, 1

];

[Anonymous]

Hi Anil

Not exactly  , I have  table like this

Load * Inline [

Uname , Udomain

Mahesh , Ind

Anil   ,   IND

John  ,  US

Perter  ,US

];

Dimenssion :

This table is data Island not associated with any other table

Load * Inline [

Test

1

2

];

[Anil_Babu_Samineni]

From here, If you select 1 from Test then which user data you want to show. I am assume you may need Applymap or atleast one similar field

How to Create Data Islands in QlikView using Data Source - Mindmajix

[Anonymous]

Hi Anil ,

Thanks For suggestion

But  the requirement was  not like this .  The list box which had added is like  Radio buttons  i.e user can select any one of it .

Already straight table  was existing , so  my job  to filter the date in st.table based on list box selection .

If the value 1 is selected from list box , i need to filter st table expression  where  expression value =1 .

Is their any way to do it from Front end .

[avinashelite · Accepted solution]

Did not get info abt your expression ..try like this

if(GetFieldSelections(Test)=1, expression1, Expression2)

or something like 

if(GetFieldSelections(Test)=1 and ,expression1=1 , Dim1)

Hope this helps you

[Anonymous]

Hi  Avinash

Thanks  Dude , It worked