Conditional Enable

[siva0606]

Hi all,

Could you please guide me to sort out this issue?

I have dimensions in list box which are similar. That mean that some of them contains same words.

Customer

Customer Phone

Customer Country

When "Customer phone" is selected, then "Customer" also auto bring in to the report.

how to restrict the "Customer" if "Customer Phone" alone selected in  list box?

Please find the attached Qlikview file for reference and Kindly do the needful.

Regards,

Sivasu

[#2 · Accepted solution]

for example like this:

=SubStringCount(Concat(Fields&'#', '|'), 'Customer#')

[siva0606]

Thanks a lot. its working now.

Can you explain me the above syntax?

Regards,

Sivasu

[#4]

this part:

Fields&'#

causes, that t oeach value of Field we concatenate '#'

To check if Customer dimension should be active we try to find 'Customer#'

So, if Customer is selected, wh have Customer# value in our concatenated string.

But if for example only Customer Phone is selected, there is no string 'Customer#' in string concatenated from possible Field values.

regatrds

D