Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set a Data Filter like Field A value = 'X'?

Dear Community members,

Sorry for such a basic question, but still struggling to find a proper place in the configuration...

On the same tab I have several charts.  And I need to hard code certain values as data filters in different charts.

For example, certain characteristic value to be fixed.  Like FRUITS_COLOR = 'GREEN', so that it is not modifiable.

And for another chart on same tab FRUITS_COLOR = 'YELLOW', for example.

Basically I would like to freeze some characteristics and remove user control to change them.

Thank you!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you looked into set analysis?

Maybe like

=sum({<FRUITS_COLOR = {'GREEN'}>} Value)

View solution in original post

5 Replies
swuehl
MVP
MVP

Have you looked into set analysis?

Maybe like

=sum({<FRUITS_COLOR = {'GREEN'}>} Value)

Colin-Albert

Have you tried using a trellis chart? This will create separate copies of your chart for each value of FRUITS_COLOR.

Not applicable
Author

Not yet! I am just a second evening with a Qlik View...

Not applicable
Author

It works just fine!  What if I need to apply same logic (fixing characteristic value) to the whole tab, where I have several charts.

So, one characteristic is commonly restricted for a group of charts, and each chart has individual restrictions on top?

What would be the syntax to list several restrictions? {<FRUITS_COLOR = {'GREEN'}>} AND {<CLIMATE = {'MODERATE'}>} ?

swuehl
MVP
MVP

{<FRUITS_COLOR = {'GREEN'}, CLIMATE = {'MODERATE'}>}

Please also have a look at the description in the Help, there are also some documents in the forum more suitable for beginners on set analysis, e.g.:

http://community.qlik.com/docs/DOC-4951

http://community.qlik.com/docs/DOC-5695

http://community.qlik.com/docs/DOC-3872

Regarding your question to fix a selection per chart:

This is not available in QV, AFAIK. You can use set analysis with aggregation functions, and you could also look into using alternate states (with maybe locked selections), to create something similar.

Please also read

http://community.qlik.com/blogs/theqlikviewblog/2014/02/03/the-key-to-heaven