Question on Qliksense filter

[pradnyat]

Hi All,

I have one table as below:

ID      Name

1        A

1       B

1        C

2         D

2          E

3          F

3          G

and I want to show 3 different filter panes for Name based on the ID e.g. filter pane 1 will have data as A B C, 2 will have D  E and 3 will have F G. And I want that these filter conditions should not imapct on each other. Hence I am writing below expressions:

Filter 1: =aggr( Only({1< id={1}>}name),name)

Filter 2: =aggr( Only({1< id={2}>}name),name)

Filter 3: =aggr( Only({1< id={3}>}name),name)

which is showing correct output but when I select filter 1 then fillter 2 values are gray out as in the backend data gets filtered out for ID=1 so there are no records for Id 2 and 3 even though I have  written 1 in expression.

Please note we have older versions on server and Alternate states are not yet available there so any way to resolve this issue.

Thanks in Advance!!

[treysmithdev]

Try:

=Only({1<id={1}>} aggr( Only({1< id={1}>}name),name))

[pradnyat]

Only function is not allowed in the dimension so I need to write another function after Only

[pradnyat]

Even when I have added 1 in set analysis to not impact on selections, when I doing aggr there dim values are getting filtered out. Any solution for this?

[treysmithdev]

You are right. What you are looking to accomplish isn't possible through Set Analysis. The field itself is filtered on so the values are excluded. By using set 1, they are still being shown, however you can't override associations, just whether they are included or not.

[pradnyat]

So is there any workaround to achieve this.

[Yoshidaqlik]

Hi,

you can create a variable and put it with the if function

Dimensions

=aggr( 
	if(id = $var,name)
,name)

Measures:

count(
	aggr( 
		if(id = $var,name)
	,name)
)

Regards