topic Re: Dimension which ignores filters in QlikView

Dimension which ignores filters

Anonymous — Mon, 21 Sep 2015 08:48:14 GMT

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

Re: Dimension which ignores filters

teiswamsler — Mon, 21 Sep 2015 11:28:42 GMT

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

Re: Dimension which ignores filters

tripatirao — Mon, 21 Sep 2015 11:30:19 GMT

Can you share sample file with your requirement

Re: Dimension which ignores filters

Anonymous — Mon, 21 Sep 2015 12:13:14 GMT

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.

Re: Dimension which ignores filters

sasiparupudi1 — Mon, 21 Sep 2015 14:20:46 GMT

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

Re: Dimension which ignores filters

Anonymous — Mon, 21 Sep 2015 14:32:30 GMT

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

Re: Dimension which ignores filters

sasiparupudi1 — Mon, 21 Sep 2015 14:42:10 GMT

Try

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

Re: Dimension which ignores filters

Anonymous — Mon, 21 Sep 2015 14:50:45 GMT

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