topic Re: Show Sheet Condition on Column Data Match in QlikView

Show Sheet Condition on Column Data Match

Wed, 10 Jul 2013 12:04:29 GMT

Hello All,

I have a document that has several customer-specific worksheets. Each one of my customers have access to only their group of facilities once they are logged in. The facilities are categorized by CustomerGroup. So Facility A thru F could be under CustomerGroup A.

Well I have a worksheet specific to CustomerGroup A. I want to write an expression of the "Show Sheet" condition that would show or hide the worksheet based on the CustomerGroup values. Side Note: Because there are several users under each CustomerGroup it would impossible to maintain a user-based condition.

So the Facilities table has the CustomerGroup column and a user could have several facilities. Is there a function that matches on a column that "contains" values versus just a one-to-one match? Such as CONTAINS(CustomerGroup, "CustomerGroup A")...

Thanks in advance,

Brian Byrdsong

Re: Show Sheet Condition on Column Data Match

Wed, 10 Jul 2013 12:15:54 GMT

Hi Brian,

please see the attached example for help.

Username: admin

Password: admin

SECTION ACCESS and SECTION APPLICATION and some small tables are used to get it to work.

Good luck!

Rainer

Re: Show Sheet Condition on Column Data Match

Wed, 10 Jul 2013 12:34:14 GMT

Thanks for the quick response! However, I failed to mention in my post that by initial load of the document, can I search thru values of a column to set the visibilty of a worksheet, not necessarily by selection?

Re: Show Sheet Condition on Column Data Match

Anonymous — Wed, 10 Jul 2013 12:59:55 GMT

match() allows you to check for more than one value. The syntax is:

match(WhatToCheckIn,WhatToCheckkWith1[,WhatToCheckkWith2,WhatToCheckkWith3 etc...])

It works like an If statement:

IF WhatToCheckIn = WhatToCheckWith1 OR WhatToCheckIn = WhatToCheckWith2 etc. THEN

If you want to dynamically create the list of Facilities which you are hoping will be in your CustomerGroup (the WhatToCheckkWith1[,WhatToCheckkWith2,WhatToCheckkWith3 etc...] bit), a Concatenate() function may be work. Something like this:

match(only(CustomerCategory),concatenate(Facilities)))

Jonathan