Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

How to display informations in range format

Hi,

I have a table that contains the students notes. for example:

Name Note

Jose  80

Carlos 60

Miguel 90

Manuel 100

Pedro 40

I would like to take out the next statistcs:

between 0 and 50: how much

between 50 and 70: how much, etc...

I'm thinking create an inline table with description ranges and in the qvw file validate using the if statement.

Anyone can help me?

1 Reply
MVP
MVP

Re: How to display informations in range format

maybe with intervalmatch function

1.png


b:

load *, from & ' to ' & to as desc inline [

from, to

0,  30

31, 50

51,99

100,200

];

a:

load * inline [

name, value

Jose,  80

Carlos, 60

Miguel, 90

Manuel, 100

Pedro, 40

];

IntervalMatch (value)

load  from, to Resident b;

Community Browser