Dual() function not working when using several measures in a plot

NicolaiF — Sat, 16 Nov 2024 05:47:17 GMT

Hi Qlik Community

I am trying to make a regular bar plot with two measures. Both measures are using the dual() function like so:

IF(AMOUNT>4,AMOUNT,dual(num('5','<#'),4))

The idea is, that when AMOUNT is below 5 the plot should display "<5" but keep an actual value of 4.

For example, if:

AMOUNT = [10, 9, 8, 7, 6, 5, 4, 3, 2, 1] 

AMOUNT displayed in plot = [10, 9, 8, 7, 6, 5, <5, <5, <5, <5]
AMOUNT actual value      = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]

When using only one measure in my plot everything works flawlessly and just like the example above but if I use two measures in my plot, let us say AMOUNT1 and AMOUNT2, the result is this:

AMOUNT1 = [10, 9, 8, 7, 6, 5, 4, 3, 2, 1] 
AMOUNT2 = [10, 9, 8, 7, 6, 5, 4, 3, 2, 1] 

AMOUNT1 displayed in plot = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]
AMOUNT1 actual value      = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]
AMOUNT2 displayed in plot = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]
AMOUNT2 actual value      = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]

Just to clarify what I need, it is this:

AMOUNT1 = [10, 9, 8, 7, 6, 5, 4, 3, 2, 1] 
AMOUNT2 = [10, 9, 8, 7, 6, 5, 4, 3, 2, 1] 

AMOUNT1 displayed in plot = [10, 9, 8, 7, 6, 5, <5, <5, <5, <5]
AMOUNT1 actual value      = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]
AMOUNT2 displayed in plot = [10, 9, 8, 7, 6, 5, <5, <5, <5, <5]
AMOUNT2 actual value      = [10, 9, 8, 7, 6, 5, 4, 4, 4, 4]

NB. I am aware that number formatting should be set to measure expression.

I hope someone knows somthing about this and is able to help, but right now, I suspect it might be a bug?

Cheers

topic Dual() function not working when using several measures in a plot in App Development

Dual() function not working when using several measures in a plot