Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
NicolaiF
Partner - Contributor II
Partner - Contributor II

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)
0 Replies