Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
];
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
];
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
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 .
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
Hi Avinash
Thanks Dude , It worked