Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get all values of field in the expression without any selection?

Hi

       Actually my scenario is something like that:

       I have 5 sheet(A,B,C,D,E) in my application and  want to show particular Sheet to particular user.

       There is one csv file which having this information:

        User, Sheet_name

        RR, A

        SM,    B

        RR,     C

        SW,    D

        MM,   E

        TT,      ALL

  I am using this expression in  show sheet condition  for each sheet.

      Sheet_name ='A' or TAB_NAME='ALL' (For sheet A)

      Sheet_name ='B' or TAB_NAME='ALL'  (For sheet B)

      Sheet_name ='C' or TAB_NAME='ALL'  (For sheet B)

      Sheet_name ='D' or TAB_NAME='ALL'  (For sheet B)

      Sheet_name ='E' or TAB_NAME='ALL'  (For sheet B)

Its working fine , if each user have single entry in csv file. But if one user have multiple entry for different sheet then it is not working. For example :- User RR having 2 entry in the list for sheet A and sheet C.  How can I show both sheet(A and C) to user RR?

I think if i can get all values of sheet_name field  without any selection then we can achieve this..

2 Replies
lironbaram
Partner - Master III
Partner - Master III

you can use

in each sheet

index(concat(Sheet_name,'|'),'A')>0 or  index(concat(Sheet_name,'|'),'ALL')>0

Not applicable
Author

Thanks Iiron, its working fine...., we can use lookup also.