Conditional Enabling Dimensions

[ivandrago]

Hi,

I have a issue with the Conditional Dimensions on the attached Document.

If I select the value "InvoiceDateBand" from the list box dim  the field InvoiceDate appears also on the table? I only want the dimension "InvoiceDateBand" to show only.

Any ideas?

Thanks

[sunny_talwar · Accepted solution]

Try now

UPDATE: Made the following changes

=SubStringCount(Concat('|' & dim & '|', ','), '|InvoiceDateBand|')

[alexpanjhc]

It maybe a bug, but if you change 'InvoiceDateBand' to 'InvDateBand' you will be seeing what you want to see.

_Dimensions:

LOAD * INLINE [dim

ID

Product

InvoiceDate

InvDateBand

];

---do not forget to change the name in the chart too.

[ivandrago]

Thanks Sunny T, any reason why my expression did not work?

[sunny_talwar]

I think the problem is that InvoiceDateBand include the SubString InvoiceDate and returns a SubStringCount of 1 even fore InvoiceDate dimension

In order to make sure that SubStringCount only gives a count for a complete fieldname match, I artificially added '|' around dim -> '|' & dim & '|' now the concatenated list will look like this -> |InvoiceDate|,|InvoiceDateBand|... and so forth and we are checking for matches with |InvoiceDate| or |InvoiceDateBand|. Here |InvoiceDate| is not a substring of |InvoiceDateBand|

Does this help?