topic Re: Sense : Color expression not respecting set analysis in App Development

Sense : Color expression not respecting set analysis

maxim1500 — Mon, 22 Feb 2016 16:45:42 GMT

I am trying to apply a color expression based on a value stored in my fact table on a bar chart. Since the fact table contains historical data, I applied a filter to get only current data.

Dimension: FactTableName.SegmentName

Measure: Sum({$<FactTableName.IsCurrent = {"true"}>}[FactTableName.TotalValue])

Everything is working so far. If I filter on a single entity, I get a single bar for his latest segment name.

But if I try to add a color expression like this:

if([FactTableName.SegmentID]=1,rgb(0,51,102),if([FactTableName.SegmentID]=2,rgb(51,51,255),if([FactTableName.SegmentID]=3,rgb(0,153,153))))

A second bar appears with a zero value (bar not visible but segment name appears on the axis) for the entity's previous segmentation.

I get the same issue with treemaps, scatter plots, etc.

Any idea on how to fix this? Color expression should not have an impact on data presentation other than setting the color...

Re: Sense : Color expression not respecting set analysis

paul_scotchford — Mon, 22 Feb 2016 21:36:50 GMT

Correct it should not affect the data preso, but I noticed in your IF there is no final colour outcome (Else) , I have added an rgb to the last else in you IF construct, see below, see how you go

if([FactTableName.SegmentID]=1,rgb(0,51,102),

if([FactTableName.SegmentID]=2,rgb(51,51,255),

if([FactTableName.SegmentID]=3,rgb(0,153,153),rgb(255,250,230)

)))

Best regards

Paul

Re: Sense : Color expression not respecting set analysis

maxim1500 — Thu, 03 Mar 2016 13:24:03 GMT

Thanks for your support. Indeed, I was missing the else condition. As for my initial issue, it is currently being escalated to the R&D team. Issue QLIK-52432.