topic Re: Conditional Enable in QlikView

Conditional Enable

siva0606 — Mon, 26 May 2014 13:51:29 GMT

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

Mon, 26 May 2014 13:57:06 GMT

for example like this:

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

siva0606 — Mon, 26 May 2014 14:05:53 GMT

Thanks a lot. its working now.

Can you explain me the above syntax?

Regards,

Sivasu

Mon, 26 May 2014 14:11:57 GMT

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