Dimension limit for middle result

Fri, 21 Apr 2017 15:54:58 GMT

Hello,

I have a classic bar chart showing Product Category in axis X and sum(SELLING_PRICE) in axis Y ordered by Y-Value descending.

I need to divide this chart in 3: Top Performing, Mid Performing, Bottom Performing depending by Y-Value.

My unique selection is Period because in each period I don't sell same PRODUCT_CATEGORY and I need to show only PRODUCT_CATEGORY sold in selected Period.

My Idea is making 3 charts , the first with Top N , the 3th with Bottom M , the 2nd with Medium P Product Category performer.

I create a Variable

vTotal = Count( distinct {<PERIOD={$(vCurrentPeriod)}>} PRODUCT_CATEGORY)

, calculated N for 1st chart:

vN = Floor(vTotal /3)

, calculated P

vP = Floor(vTotal /3)

, calculated M

vM = vTotal - vN - vP

So, for first chart I used Dimension Limit for TOP vN elements, for 3th chart I used BOTTOM vM elements... and for 2nd chart?

How can I select elements in the middle?

Could I define a PRODUCT_CATEGORY set including all PRODUCT_CATEGORY not in 1st chart and not in 3th chart?

Someone has few suggestion for do this?

I'm using QlikView 11.20

topic Dimension limit for middle result in QlikView

Dimension limit for middle result