Dimension which ignores filters

[Anonymous]

Hello

Is there any way to that a Dimension ignores filters? I've create some buttons to filter the report applying a Dimension's values and I want to be able to get all possible values of that dimensions ignoring the value filtered.

I've tried with Set Analysis, but this is applied to aggregate functions, not to dimensiones.

concat({$<CLIENT_GROUP_TYPE=>}CLIENT_GROUP_TYPE, ',')

Thanks

[teiswamsler]

Hi Marcos

Use same ideer in the chart expression not in the dimoensions

ex.

Sum( { $<CLIENT_GROUP_TYPE= >} Sales )

This will ignore selection made in field CLIENT_GROUP_TYPE

/Teis

[tripatirao]

Hi

Can you share sample file with your requirement

[Anonymous]

Hi

Thanks by your replies.

My issue is not about a chart, i'm trying to invest the usability of my report. To achieve it we've thought to use a custom menu to filter the report. I'm using images in three labels (GRAY - ORANGE - BLUE). Each color means a state: gray disabled, blue enabled and orange active selection.

If I select a Client's Group those buttons will repaint: if my Client's Group has each Type, icons will be enabled and displayed with blue background; however, if there are any Type that the Client's Group doens't have, then the button is showed with grey background. I achieve it using the function concat.

When I select a Type, this is showed with orange background and it filters the dimension Type to corresponding value. What happens here? the only selectable value of Type is the value that I've just selected, so the other buttons are automatically disabled and grey painted.

I want to control when the buttons are disabled and gray painted: only when the Client's Group doesn't have them, otherwise the button should be enable and display with blue background.

For example, for the first button (gray label):

Layout > Show > Conditionl:

SubStringCount(concat(CLIENT_GROUP_TYPE, ','), '1') = 0

Note: This is only showed when the value 1 of the selectable values of the dimension is not allowed.

I need to add to that condition that it should ignores the explicit filter applied on the dimension CLIENT_GROUP_TYPE, so, if I selected the Type 2 (teeth icon) and the Client's Group has the Types 1 and 3, these should be showed in blue.

I hope that I've explained well my issue.

Thanks by your time.

[sasiparupudi1]

concat( {1<CLIENT_GROUP_TYPE=>} distinct CLIENT_GROUP_TYPE,', ')

[Anonymous]

Sasidhar thanks by your suggestions, but if I use the identifier "1", i get all posible values of CLIENT_GROUP_TYPE ignoring the Client's Group filter.

Cheers

[sasiparupudi1]

Try

concat( {<CLIENT_GROUP_TYPE=p (CLIENT_GROUP_TYPE ) >} distinctCLIENT_GROUP_TYPE,', ')

[Anonymous]

Hi Sasidhar,

Thanks again for your time. I thought to use p() operator, but the result is similar to use concat function, I only get the posible values based on my current selection.

Cheers