Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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!

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

Have you looked into set analysis?

Maybe like

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

View solution in original post

5 Replies
Highlighted
MVP
MVP

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

Have you looked into set analysis?

Maybe like

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

View solution in original post

Highlighted

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

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

Highlighted
Not applicable

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

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

Not applicable

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

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'}>} ?

Highlighted
MVP
MVP

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

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