Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 
Not applicable

On the fly IntervalMatch (kind of)???

Hi everyone,

Need to build an expression that do something similar to a IntervalMatch, but on the front-end.

In other words, from a table like the one below:

Grade | Rate

    0    |  1

  4,5   |  2

  4,6   |  3

  4,7   |  4

So, if our grade is above 0 and less than 4,5 the rate is 1, if is above 4,5 and less than 4,6 the rate is 2, etc.

The grade metric depends on the selections, so it can not be calculated in advance.

At this point I can only assign it to the total value of the aggregation (the value of total row of the table). On the attachment you have a dummy data set to walk you through the problem.

Thanks in advance,

1 Solution

Accepted Solutions

Check the attached

View solution in original post

2 Replies

Check the attached

View solution in original post

Not applicable

Thank you very much!