Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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

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

Labels (2)