Ad -hoc reporting?

[Anonymous]

=SubStringCount(Concat(Dimensional_columns, '|'), 'Country')

How to understand this function in dimension tab condition?

[sunny_talwar]

If Country is selected in Dimensional_columns, the expression will give you 1, otherwise 0... is that what you were trying to understand?

[Anonymous · Accepted solution]

Hi

Concat(dimension, '|') - gives the dimensions concatenate by pipe symbol.

SubstringCount() - gives the number of occurrance of substring matches in the string.

Hope it helps!!

[dhasharadh]

the given exp used to generate adhoc reports/ customized charts.

'Dimensional_columns'  is the heading for the all the dimensions , where as  'Country' is the first in the list of dimensions under that heading.

we have to use this condition to enable that particular dimension.

refer this https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table