topic Re: Ad -hoc reporting? in QlikView https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366122#M835583 <HTML><HEAD></HEAD><BODY><P>If Country is selected in Dimensional_columns, the expression will give you 1, otherwise 0... is that what you were trying to understand?</P></BODY></HTML> Wed, 31 May 2017 11:59:04 GMT sunny_talwar 2017-05-31T11:59:04Z Ad -hoc reporting? https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366121#M835582 <HTML><HEAD></HEAD><BODY><P>=SubStringCount(Concat(Dimensional_columns, '|'), 'Country')</P><P></P><P>How to understand this function in dimension tab condition?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366121#M835582 Anonymous 2020-11-25T16:16:04Z Re: Ad -hoc reporting? https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366122#M835583 <HTML><HEAD></HEAD><BODY><P>If Country is selected in Dimensional_columns, the expression will give you 1, otherwise 0... is that what you were trying to understand?</P></BODY></HTML> Wed, 31 May 2017 11:59:04 GMT https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366122#M835583 sunny_talwar 2017-05-31T11:59:04Z Re: Ad -hoc reporting? https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366123#M835584 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi</P><P style="font-size: 13.3333px;"></P><P style="font-family: inherit; font-size: 13.3333px; font-style: inherit; font-weight: inherit;">Concat(dimension, '|') - gives the dimensions concatenate by pipe symbol.</P><P style="font-family: inherit; font-size: 13.3333px; font-style: inherit; font-weight: inherit;">SubstringCount() - gives the number of occurrance of substring matches in the string.</P><P style="font-family: inherit; font-size: 13.3333px; font-style: inherit; font-weight: inherit;"></P><P style="font-family: inherit; font-size: 13.3333px; font-style: inherit; font-weight: inherit;"></P><P style="font-family: inherit; font-size: 13.3333px; font-style: inherit; font-weight: inherit;">Hope it helps!!</P></BODY></HTML> Wed, 31 May 2017 12:13:29 GMT https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366123#M835584 Anonymous 2017-05-31T12:13:29Z Re: Ad -hoc reporting? https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366124#M835585 <HTML><HEAD></HEAD><BODY><P>the given exp used to generate adhoc reports/ customized charts.</P><P></P><P>'Dimensional_columns'&nbsp; is the heading for the all the dimensions , where as&nbsp; 'Country' is the first in the list of dimensions under that heading.</P><P></P><P>we have to use this condition to enable that particular dimension.</P><P></P><P>refer this <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table">https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table</A></P></BODY></HTML> Wed, 31 May 2017 12:47:15 GMT https://community.qlik.com/t5/QlikView/Ad-hoc-reporting/m-p/1366124#M835585 dhasharadh 2017-05-31T12:47:15Z