Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Filter - Select All Update

Hello -

I have a graph that requires multiple filters to be used; however, when the data is reloaded it messes with one of my bookmarked filters.

Background:

I needed a filter where the following condition is met:  Ability to identify all Procedures where the Procedure is = A and the Key doesn't have multiple Procedure associated to it.

example:

Key   Procedure

1     A

2     B

3     A

3     B

3     C

4     A

4     B

5     C

6     A

In this case, I'd like for it to return

Key

1

6

To do this I created a Count(DISTINCT [Procedure]) as PPCount in the load script and grouped by Key.  Then I created a filter with the following expression: Aggr(Only({<PPCount = {1}, Procedure = {Screening'}>} Key), Key)

The above expression gives me the correct list of all Keys.  Then I use the select all option and it properly gives the result i'm looking for on the bar graph. However, once I do a data reload and select the bookmark the filter is no longer selecting all Keys.  I have to clear the filter and reselect all for it to populate correctly.

My question:  Is there a way for me to get the filter to properly update after a data load or construct the expression in a different way where a data load wouldn't mess with the bookmarked filter?

Thanks!!

1 Reply
zhadrakas
Valued Contributor

Re: Filter - Select All Update

Hello Matt,

can you share your qvw?

Community Browser