Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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