topic How to display informations in range format in Qlik Learning Discussions

How to display informations in range format

Wed, 12 Nov 2014 22:18:38 GMT

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?

maxgro — Wed, 12 Nov 2014 22:25:50 GMT

maybe with intervalmatch function

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

from, to

0, 30

31, 50

51,99

100,200

];

load * inline [

name, value

Jose, 80

Carlos, 60

Miguel, 90

Manuel, 100

Pedro, 40

];

IntervalMatch (value)

load from, to Resident b;