Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to define dimension names basing on numeric intervals on charts.
Intervals will need to be defined manually, directly on chart.
if((A between 1 and 2),'First interval')
if((C between 3 and 4),'Second interval')
I have been unsuccesfully searching for 'between' replacement in qliksense, but did not find any.
How would you suggest to tackle that?
Hi @Mt3 , here a couple of options.
In script try the intervalmatch function, in charts try the rank function
intervalmatch
rank
Thank you for the hint! Thing is, i need to define intervals manually in the chart, guess the rank function will not work here.
what do you mean by "define intervals manually in the chart"?
Hi @Mt3 , i tried this :
Data:
Data:
Load * INLINE [
Field1, Field2
1, 34
2, 65
3, 87
4, 345
5, 98
6, 23
7, 76
8, 21
9, 32
10, 89
];
Bar Chart Dimension
=if(Field1 >= 1 and Field1 <=4 , 'A',
if(Field1 >= 5 and Field1 >= 8 , 'B','C'))
bar chart measure
Sum(Field2)