Dimension - numeric intervals - chart function - Qlik Community

Mt3 · ‎2022-09-30

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?

QFabian · ‎2022-09-30

Hi @Mt3 , here a couple of options.

In script try the intervalmatch function, in charts try the rank function

intervalmatch

rank

QFabian

Mt3 · ‎2022-09-30

Thank you for the hint! Thing is, i need to define intervals manually in the chart, guess the rank function will not work here.

MarcoWedel · ‎2022-09-30

what do you mean by "define intervals manually in the chart"?

QFabian · ‎2022-09-30

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)

QFabian

Dimension - numeric intervals - chart function