Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Have you looked into set analysis?
Maybe like
=sum({<FRUITS_COLOR = {'GREEN'}>} Value)
Have you looked into set analysis?
Maybe like
=sum({<FRUITS_COLOR = {'GREEN'}>} Value)
Have you tried using a trellis chart? This will create separate copies of your chart for each value of FRUITS_COLOR.
Not yet! I am just a second evening with a Qlik View...
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'}>} ?
{<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