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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.