topic Conditional Enabling Dimensions in QlikView

Conditional Enabling Dimensions

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional Enabling Dimensions

sunny_talwar — Wed, 31 Aug 2016 16:14:31 GMT

Try now

UPDATE: Made the following changes

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

Re: Conditional Enabling Dimensions

alexpanjhc — Wed, 31 Aug 2016 16:19:19 GMT

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

_Dimensions:

LOAD * INLINE [dim

Product

InvoiceDate

InvDateBand

];

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

Re: Conditional Enabling Dimensions

ivandrago — Wed, 31 Aug 2016 19:45:57 GMT

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

Re: Conditional Enabling Dimensions

sunny_talwar — Wed, 31 Aug 2016 21:06:45 GMT

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

Does this help?