Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
(Please ignore the Actual value as it is in -ve)
I have a table with top 10 values + others. My requirement is when I click the Others, I should get the further top 10 values (values which comprise to make Others ).
But Row with 'Others' is not available for selection.
Could anyone know how to do that? or any other work around to achieve the same.
Thanks
Gayatri
This is how Qlik works by default if you used the Dimension setting for "Limitation" (and then e.g. "Fixed - top 10"). Clicking "Others" will perform a selection on the dimension field which includes all values in the table not currently displayed.
Note that this will not be able to select null values in the dimension so if you have those and want them included, you will need to replace the nulls with something that can be selected.
Clicking "Others" will perform a selection on the dimension field which includes all values in the table not currently displayed.
For your above line.. when I am clicking 'Others' nothing is happening. I am not able to see any dimension field which comes under 'Others'
I'm not sure what your object is doing, but as far as I know this is the default behavior assuming your "Others" field is achieved through the dimension limitation and your dimension field allows selections and isn't some sort of complex calculated dimension which can't be selected on. I've confirmed this with a test app.