Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

faizoelactive
New Contributor III

Set analysis "ignored" when applying background color to dimension

Hi In sense v3.2 SR1 3.1 SR2(server) I'm having an issue in a table.

When I add a measure with a set analysis the table is reduced to only the data for that set.

After I add a background color, or text this set-analysis all data is shown, disregarding the set analysis.

Is this a known "feature", or is this a bug and is it solved in a later version? At the client I'm with there is not a way to quickly update to a new version and see what changes.

Anyone know how to work around this?

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis "ignored" when applying background color to dimension

Is your background color based on a measure, e.g. using a condition?

Then add set analysis to this measure , too. Use Only() function, if needed, to be able to use a set expression.

3 Replies

Re: Set analysis "ignored" when applying background color to dimension

Would you be able to share a sample to show this issue?

MVP
MVP

Re: Set analysis "ignored" when applying background color to dimension

Is your background color based on a measure, e.g. using a condition?

Then add set analysis to this measure , too. Use Only() function, if needed, to be able to use a set expression.

faizoelactive
New Contributor III

Re: Set analysis "ignored" when applying background color to dimension

Hi Thanks for this suggestion. I had seen that before, but didn't try. This still didn't work. In the end I created the calculations in the script so that I had the RGB color for each record.

I then used a Max({<Status = {'status'}>}[color field]). This did the trick.

So lesson learned is also apply set analysis to the background color expression.

edit: missed the set analysis part in your message. With set analysis it also works with only. Thanks for the help!

Community Browser