topic Re: Conditional show in QlikView

Conditional show

Fri, 19 Sep 2014 15:28:06 GMT

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

Re: Conditional show

Anonymous — Fri, 19 Sep 2014 15:40:00 GMT

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

Re: Conditional show

JonnyPoole — Fri, 19 Sep 2014 15:50:22 GMT

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

Re: Conditional show

sundarakumar — Sat, 20 Sep 2014 13:35:14 GMT

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