Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try now
UPDATE: Made the following changes
=SubStringCount(Concat('|' & dim & '|', ','), '|InvoiceDateBand|')
Try now
UPDATE: Made the following changes
=SubStringCount(Concat('|' & dim & '|', ','), '|InvoiceDateBand|')
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.
Thanks Sunny T, any reason why my expression did not work?
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?