Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional show

Hi All,

     Is it possible to perform conditional show of Sheets/Objects based on the table entries. I have table which will hold all the values of Tab, Object id. Is it possible to create conditional show??

DashboardNameTabNameObjectIDOSUser
DB1Tab1DD01User1
DB1Tab1DD02User1
DB1Tab1DD03User1
DB1Tab1DD04User1
DB1Tab2DD05User1
DB1Tab2DD06User1
DB1Tab2DD07User1
DB1Tab1DD08User2
DB1Tab1DD09User2
DB1Tab1DD10User2
DB1Tab1DD11User2
DB1Tab1DD12User2
DB1Tab1DD13User2
DB1Tab1DD14User2
3 Replies
Anonymous
Not applicable
Author

Hello QV Learner,

I dont understand very well your question.

You want to show some objects or NOT based in a tab of qlikview or a specific filter of tab?

Best regards,

Morandi

JonnyPoole
Employee
Employee

Yes.  Use something like this in the show/hide condition of an individual dashborad object

  if(  substringcount( concat(distinct [Object ID],';') , ' <TheObjectIDOfTheObject>') > 0 ,1,0)

It will show the object if the [Object ID] values for the current selection includes the object id of the current object

sundarakumar
Specialist II
Specialist II

s it is very well possible,

first load the table as an inline table and use like

if(  substringcount( concat(distinct [Object ID],';') , ' <TheObjectIDOfTheObject>') > 0

     and substringcount( concat(distinct [OSUser],';') ,' $(=osuser())') > 0 ,1,0)

Pls add the dashboard name to all the objects to avoid one more if statement to this..

hope this helps..

-Sundar