qliksense filter required !!!!

[qliklearnervir]

Hi ,

I am trying one expression in qliksense filter ...but not wokring...please suggest.

=if(RIGHT(TEXT(osuser()),7)=APP_OWNER_SID,'My Apps',

if(RIGHT(TEXT(osuser()),7)=APP_OWNER_SID OR RIGHT(TEXT(osuser()),7)<> APP_OWNER_SID OR,'All Apps',''))

as per this formula  i want to categories MY app and all apps according to AAP_OWNER_SID .

if my loginmap with APP_ONWER_SID than these are my apps

else all apps.

please suggest

[groveliam]

check out vizlib filter

[rittermd]

Where are you trying to use this code?  Can you give me examples of some real values in these fields and what your data model looks like?

[balabhaskarqlik]

May be this:

=if(RIGHT(TEXT(osuser()),7)=APP_OWNER_SID, 'My Apps',

          if(RIGHT(TEXT(osuser()),7) <> APP_OWNER_SID,'All Apps',''))

[qliklearnervir]

Hi Actual my scenario is like :

As a owner of data ,once you login than only whoever data you own can see in My data ...rest in All data

like we have table like that

Apps,Apps_owner_id

whatever  Apps_owner_id belongs to login user ....than data should come in my data .....else other should be all data in filter list box in qliksense

[qliklearnervir]

Data example:

this is our data not qlik sense app ....so please do not confuse ....

Apps      Apps_Owner_ID

A1         001

A2         002

A3         003

now for example if i am login to qlik sense and my osuser sid is 001 than in in filter "My View"   i can see the data for A1   and for filter "All View" i can see the data for A1,A2,A3 .

is this possible in qliksense that we can create list box filter like that . similar to qlikview

[rupamjyotidas]

Move it to the Script and build a new field.

[qliklearnervir]

can you suggest somw code...as my apps is possible but for all apps we should have some action trigger.

[qliklearnervir]

ANY SUGGESTION ??????