i loaded some data in the load editor as follows:
load * inline [
And was able to get the desired output using the following calculated dimension and measure:
Dimension: if( aggr(sum(Temperatur),CreatedDate) < 0 ,CreatedDate)
...ensuring 'show null values' is unchecked
Measure: Sum( if( Temperatur<0,fabs(Temperatur)))
The chart and table on the top row below is the native data.
The 2nd row has just the negatives showing as positives.
with FABS(expression) you can bring the neg. values on the upper half of the x-axis (together with the pos. values).
The problem is to get the minus sign in front of this values, because you can't enter an expression in the format pattern field etc.
The only way to bring both together would be to create two measures (one for pos & one for neg values) but also means that pos. & neg. bars are slightly offset & in the popup label both measures are visible.
blue= neg. values (incl. "-" in the popup label)
red= pos values
I am not sure if there is better solution to achieve what you need at the moment in QSense.
e.g. 1 only has a neg. value and also a 0 value for second expression (pos. temperature).
As soon one of the two expressions has a value <>0 , both will be displayed on the graph.
You can't eliminate the zero value of just one of the expressions. both or non.
I think there is not a hundred percent solution for your requirements at the moment in Qlik Sense.
1) You can achieve only 1 bar per dimension value, if you can replace "-"sign by color, etc.
2) You can achieve "-" for neg. values in popup label but then you have 2 bars per dimension value (single zero value can't be eliminate)