topic Re: st.table in QlikView

st.table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Test

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

Re: st.table

Anil_Babu_Samineni — Wed, 08 Mar 2017 08:45:46 GMT

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

];

Re: st.table

Anonymous — Wed, 08 Mar 2017 08:50:10 GMT

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

];

Re: st.table

Anil_Babu_Samineni — Wed, 08 Mar 2017 08:56:46 GMT

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

Re: st.table

Anonymous — Wed, 08 Mar 2017 09:07:41 GMT

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 .

Re: st.table

avinashelite — Wed, 08 Mar 2017 09:41:55 GMT

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

Re: st.table

Anonymous — Thu, 09 Mar 2017 05:22:39 GMT

Hi Avinash

Thanks Dude , It worked