Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
DashboardName | TabName | ObjectID | OSUser |
DB1 | Tab1 | DD01 | User1 |
DB1 | Tab1 | DD02 | User1 |
DB1 | Tab1 | DD03 | User1 |
DB1 | Tab1 | DD04 | User1 |
DB1 | Tab2 | DD05 | User1 |
DB1 | Tab2 | DD06 | User1 |
DB1 | Tab2 | DD07 | User1 |
DB1 | Tab1 | DD08 | User2 |
DB1 | Tab1 | DD09 | User2 |
DB1 | Tab1 | DD10 | User2 |
DB1 | Tab1 | DD11 | User2 |
DB1 | Tab1 | DD12 | User2 |
DB1 | Tab1 | DD13 | User2 |
DB1 | Tab1 | DD14 | User2 |
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
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
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