Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Question on Qliksense filter

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!!

6 Replies
Highlighted
Luminary
Luminary

Try:

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

Blog: WhereClause   Twitter: @treysmithdev
Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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?

Highlighted
Luminary
Luminary

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.

Blog: WhereClause   Twitter: @treysmithdev
Highlighted
Creator
Creator

So is there any workaround to achieve this.

Highlighted
Creator II
Creator II

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

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng