I have a QlikView dashboard with a pivot table displaying as a heat map. Currently, the conditions test against the cell values for the whole of the pivot table (including the Totals column).
So, for example, my horizontal axis (columns) uses a dimension called 'Lesson type', which displays as 10 columns. I would like to apply a different test on each column, rather than a single test on all columns.
Is it possible to apply different tests to specific columns ?