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

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

Wed, 05 Feb 2014 23:06:01 GMT

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!

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

swuehl — Wed, 05 Feb 2014 23:10:22 GMT

Have you looked into set analysis?

Maybe like

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

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

Colin-Albert — Wed, 05 Feb 2014 23:14:01 GMT

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

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

Wed, 05 Feb 2014 23:28:58 GMT

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

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

Wed, 05 Feb 2014 23:33:59 GMT

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

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

swuehl — Thu, 06 Feb 2014 19:00:00 GMT

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