topic Re: Selecting Multiple Dimensions in Error in QlikView

Selecting Multiple Dimensions in Error

Anonymous — Mon, 13 Jul 2015 14:22:38 GMT

I have a list of dimensions which users can choose from to populate a table.

In the straight table chart, I have the following formula in the "Enable Conditional" field in the Dimensions tab:

=SubStringCount(Concat(_Dimension,'|'), 'Field Name')

This is causing an issue for fields with similar names. For example, I have Account Code and Allocation Account Code. When the user chooses Allocation Account Code it populates the table with the Account Code field AND the Allocation Account Code field.

I would like the table to only populate for the Allocation Account Code.

Any ideas?

Thank you,

- dave

Re: Selecting Multiple Dimensions in Error

jonathandienst — Mon, 13 Jul 2015 14:27:21 GMT

Try something like this:

SubStringCount('|' & Concat(_Dimension,'|') & '|', '|Field Name|')

(all fields, including the first and last, are bounded by | characters)

Re: Selecting Multiple Dimensions in Error

antoniotiman — Mon, 13 Jul 2015 14:46:00 GMT

Hi David,

excellent Jonathan' solution.

Another way is

Your Dimension Table

_dimension,_description

AccCode,Account Code

AllAccCode,Allocation Account Code

......

Conditional Expression :

SubStringCount(Concat(_dimension,'|'),'AccCode')

Your List Box :

_description

Regards,

Antonio

Re: Selecting Multiple Dimensions in Error

Anonymous — Mon, 13 Jul 2015 15:08:49 GMT

Thank you for both of your responses. Jonathan's solution was most easy to apply so I went with that. Appreciate the help per usual.