Conditional Formatting according to the dimension selection.

Apliqo UX
1

Hi,

I need to define a conditional formatting. But it should work if and only if the “GM%” is selected from the measure filter.

As you can see below currently it works even the FTE is selected. Is it possible to define this kind of a condition? As far as I understand we can only define a condition based on the cell value of the same column or cell value of another column in the view. Can we define it for a dimension selection?

image
image1820×361 124 KB

I have tried something like this “=IF($<<Forecast.GP Time Allocation m.GP Time Allocation m>> = “GM %”,1,3)” in an inserted column but it doesnt work.

2

Ir’s possible but you need to be creative. Setting service variables are recognized only withing the context of arguments within a DBRW formula. So you could insert a column and do a DBRW to the element attributes cube of the dimension that GM% is from so that the column value for all cells returns the value of the filter. Then you can use this value for your conditional formatting.

2 Likes
3

I am trying to set this kind of a conditional formatting below:

"columnFormat": {
      "Jun-25": [
        {
          "dataColumn": "Inserted 0",
          "condition": "!=",
          "value": "1",
          "className": ""
        },
        {
          "dataColumn": "Jun-25",
          "condition": "<",
          "value": "0",
          "className": "cell-icon-error"
        },
        {
          "dataColumn": "Jun-25",
          "condition": ">",
          "value": "1",
          "className": "cell-icon-error"
        },
        {
          "dataColumn": "Jun-25",
          "condition": "=",
          "value": "0",
          "className": ""
        },
        {
          "dataColumn": "Jun-25",
          "condition": "<",
          "value": "0.3",
          "className": "cell-status-open"
        }
      ],

However since I set the data column as the inserted column in the first condition, other conditions also works according to the value in the inserted column. Is there a way to change the datacolumn for each condition? Even I define data column for each and every condition still it doesnt work.

4

can’t really tell what you are trying to do. Maybe describe in words?

5

image
image1261×375 126 KB

I have a view like this. I need to set conditional formatting only for “GM %”. For other measures conditional formatting must not work at all.

If the measure selection is “GM %” the inserted column value is 1 if not 0. So I need to set a condition like if the inserted column value is 1 it will work if not it will not work.

The issue that I am facing is once I define the datacolumn as inserted column, I cant change it.
Here in the first condition I define it as inserted column.

"columnFormat": {
      "Jun-25": [
        {
          "dataColumn": "Inserted 0",
          "condition": "!=",
          "value": "1",
          "className": ""
        },

But starting from the second condition I want to use the values of the column that I am defining the conditional formatting for. However if I dont define the datacolumn in the second condition, It still takes the values from the inserted column.

,
        {
          "condition": "<",
          "value": "0",
          "className": "cell-icon-error"
        },

If I define the datacolumn in my second condition, still it doesnt work and it continues to get the data from the inserted column.

,
        {
          "dataColumn": "Jun-25",
          "condition": "<",
          "value": "0",
          "className": "cell-icon-error"
        },

So the question is, starting from the second condition, how can I start to use the values of the column that I define the condition for?