I am somewhat new to Qlik Sense and am setting up a pivot table. My data is set up in such a way that there is a value field with a number, and an "Attribute" field. The "Attribute" field is being used to list out the values. An example of the data is shown below, and I would like to reflect the formatting similarly in the pivot table.
|01: Sales|| 100,000.00 |
|02: Cost of Sales|| 90,000.00 |
|03: Gross Margin|| 10,000.00 |
|04: Operating Expenses|| 5,000.00 |
|05: Operating Margin|| 5,000.00 |
|06: OM %||5.00%|
|07: Adjusted %||3.00%|
|08: Adjustment|| (2,000.00)|
After playing around with the expression formulas for the value, I have found that it is possible to determine formatting via formula, however I am having trouble with formulating the logic to make it format based on the Attribute.
This is as far as I have gotten, but it is currently reading the condition as false, and thus formatting everything as a percentage.
Is it possible to format conditionally in a pivot table?
Any thoughts are quite welcome.