Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check out vizlib filter
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?
May be this:
=if(RIGHT(TEXT(osuser()),7)=APP_OWNER_SID, 'My Apps',
if(RIGHT(TEXT(osuser()),7) <> APP_OWNER_SID,'All Apps',''))
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
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
Move it to the Script and build a new field.
can you suggest somw code...as my apps is possible but for all apps we should have some action trigger.
ANY SUGGESTION ??????