Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to compare a calculated value to a set of intervals?

Hi,

the attachment explains what I'm trying to do..

I want to display in a table, a qualifier depending on a calcul.

I've got 2 table, on for the indicator calcul, the other not linked to the first one, containing intervals with the qualifier for each.

How to display the good qualifier depending on the indicator result & the interval match without precomputing indicator..

thanks upfront.

3 Replies
jagannalla
Valued Contributor III

how to compare a calculated value to a set of intervals?

Hello,

There is now link between two tables and more over we are generating Indicatior exp in chart. Why can't you hard code it.

If that is in the case you can use below code in corresponding level expression in chart

=if(column(4)>=0 AND column(4)<0.4,'Unacceptable',

    if(column(4)>=0.4 AND column(4)<0.6,'Bad',

        if(column(4)>=0.6 AND column(4)<0.8,'Good',

            if(column(4)>=0.8 AND column(4)<1,'Excelent'))))

Not applicable

how to compare a calculated value to a set of intervals?

thanks,

The level table should come from a flat file reguraly modified (not a load inline).

File would be maintained by business. SO when they modify the file, intervals should be reloaded in the application.

MVP
MVP

Re: how to compare a calculated value to a set of intervals?

Hi

Be careful of expressions that use fields from two (or more) unconnected tables. If the dataset is small, they will perform OK, but if it is larger, you will run into "out of memory" errors when QV tries to create a cross join to perform the calculations.

You are better off using intervalmatch when reloading. From your second post, that would seem to be the correct way. Search the forum for intervalmatch, there are many postings on the topic, and check out intervalmatch in the manual.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser