topic Re: Set analysis on a dimension used for color coding in App Development

Set analysis on a dimension used for color coding

mkliqvia — Sat, 16 Nov 2024 19:38:36 GMT

Hi all,

I have following data in my app, with both fields not related to each other:

In the app, we have a filter on 'Customer status', which is always on value ACTV.

I have a bar chart which shows data on the 'Activity Type' (stacked bar chart with color coding in function of the 'Activity Type').

- When Customer status = ACTV is not selected, the colors for each 'Activity Type' work correctly.
- but when Customer status = ACTV is selected (default), the colors are not shown. So I try to find a way to make that dimension ignore the filter on Customer status.

I have tried multiple solutions to have the Color by Dimension ignore the filter on [Customer status], but they don't seem to work:

- aggr(only({<[Customer status]=>} [Activity Type]),[Activity Type])
- concat({<[Customer status]=>} distinct [Activity Type], ',')
- aggr(concat({<[Customer status]=>} distinct [Activity Type],','),[Activity Type])

Do you have any idea what other possible solutions I could try?

For info, with color coding set to 'Single Color', I can see the activity types stacks, but cannot color each of them (see image). While when no selection is made on the ACTV value, the colors are rendered well (one for each activity type).

Re: Set analysis on a dimension used for color coding

JordyWegman — Wed, 20 Nov 2019 08:37:27 GMT

Hi,

Any possibility to share the QVF? This will make it easier to fix the problem.

Jordy

Climber

Re: Set analysis on a dimension used for color coding

mkliqvia — Wed, 20 Nov 2019 13:50:51 GMT

Hi,

There is confidential information in this QVF, so I cannot share it 😕

Re: Set analysis on a dimension used for color coding

sunny_talwar — Wed, 20 Nov 2019 14:14:35 GMT

Are you using a color expression for color?

Re: Set analysis on a dimension used for color coding

JordyWegman — Wed, 20 Nov 2019 15:06:51 GMT

Hi,

Try this:

- aggr({<[Customer status]=>}only({<[Customer status]=>} [Activity Type]),[Activity Type]) - concat({<[Customer status]=>} distinct [Activity Type], ',') - aggr({<[Customer status]=>}concat({<[Customer status]=>} distinct [Activity Type],','),[Activity Type]

I think you need the set analysis also in the aggregation.

Jordy

Climber

Re: Set analysis on a dimension used for color coding

mkliqvia — Wed, 20 Nov 2019 15:19:06 GMT

In the Colors and legend part of the bar chart, I use color 'By Dimension'. There I write the expression in the 'select dimension' box.

Re: Set analysis on a dimension used for color coding

sunny_talwar — Wed, 20 Nov 2019 15:25:19 GMT

Have not tried that before, but where do you specify the color for each dimension? It is determined on it's own? May be try this

only({<[Customer status]=>} [Activity Type])

Re: Set analysis on a dimension used for color coding

mkliqvia — Wed, 20 Nov 2019 15:27:03 GMT

Thanks, I tried the 3 of them (in the color 'By Dimension', pasting it in the dimension field, but it didn't work.

Re: Set analysis on a dimension used for color coding

mkliqvia — Wed, 20 Nov 2019 15:37:39 GMT

Thanks for the suggestion, but it didn't work.

Here's where I pasted the code:

Re: Set analysis on a dimension used for color coding

sunny_talwar — Wed, 20 Nov 2019 15:42:22 GMT

Just out of curiosity, are you ignore selection in [Customer status] field within your expression or not?

Re: Set analysis on a dimension used for color coding

mkliqvia — Wed, 20 Nov 2019 16:13:21 GMT

That's where I used your suggested code:

only({<[Customer status]=>} [Activity Type])

Re: Set analysis on a dimension used for color coding

sunny_talwar — Wed, 20 Nov 2019 16:32:59 GMT

I meant the chart Measure

Re: Set analysis on a dimension used for color coding

mkliqvia — Fri, 22 Nov 2019 10:36:46 GMT

Yes the chart measure ignores the Customer_Status field as well.

Re: Set analysis on a dimension used for color coding

sunny_talwar — Fri, 22 Nov 2019 11:53:24 GMT

I am not sure what might be going on. Would you be able to share a sample to show the issue?

Re: Set analysis on a dimension used for color coding

mkliqvia — Tue, 26 Nov 2019 08:48:02 GMT

Unfortunately, I cannot share the app. But how can we make the set analysis ignore the NULL values ? These fields come from two separate tables where the keys don't match, therefore creates these NULL values.