topic Re: Dimension - numeric intervals - chart function in App Development

Dimension - numeric intervals - chart function

Mt3 — Fri, 30 Sep 2022 13:32:49 GMT

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 — Fri, 30 Sep 2022 12:54:41 GMT

Hi @Mt3 , here a couple of options.

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

intervalmatch

rank

Mt3 — Fri, 30 Sep 2022 13:34:05 GMT

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 — Fri, 30 Sep 2022 15:02:53 GMT

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

QFabian — Fri, 30 Sep 2022 15:07:16 GMT

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)