topic CLASS FUNCTION ISSUE in QlikView

CLASS FUNCTION ISSUE

Mon, 08 Sep 2014 15:15:23 GMT

Attached please find the Straight Table. I am using the Class Function to Do my intervals. The intervals are for the Dimenion "Score". The Max Score is 100.

I am good every where Except when it comes to the Interval of >=95 and <100 (127) and >100 <105 (68), I want the the (68) to be a Part of >=95 and <100 so the Correct Total should be (127+68). How can I accomplish that

Re: CLASS FUNCTION ISSUE

MK_QSL — Mon, 08 Sep 2014 15:22:38 GMT

Provide sample data please....

For such requirement, you need to use If function rather than Class....due to having different range...

Re: CLASS FUNCTION ISSUE

Mon, 08 Sep 2014 15:24:27 GMT

Rehan

Are you saying that the max score is 100? If so where do the scores come from that are above 100?

I would create a sort order on your class dimension to clean up the display.

Can you create a Text object to display =max(Score) ? and verify the data?

It may be helpful if you could post an example?

Richard