topic Sorting in Trellis chart in QlikView

Sorting in Trellis chart

Fri, 29 Apr 2011 10:14:00 GMT

Hi all,

I'm having some problem sorting the bars in a trellis chart. I want to sort it by the expression value. But it doesn't seems to work.

Any work around for this one?

AW:Sorting in Trellis chart

brenner_martina — Fri, 29 Apr 2011 11:05:24 GMT

Hi,

I thing, it sort right, it sorts now descending in SUM of All values, not only one chart by its own.

Sorting in Trellis chart

Mon, 09 May 2011 02:27:29 GMT

Sorry if my question is not clear. But how can I sort the chart based on the 2nd dimension in trellis? (international & domestic)

Sorting in Trellis chart

erichshiino — Mon, 09 May 2011 03:06:20 GMT

I'm not sure I got your question right...

I also think this result is right. You got international first because in total (it seems to be) larger.

You got 'Better Large...' as the first product because the total result makes it the top product.

I think you would like to see 'Red Spade' as the first product for 'Domestic' but the product sorting criteria is independent of the type (international or domestic). I believe this help you compare the results between the dimensions on the trellis.

Sorting in Trellis chart

Tue, 10 May 2011 02:23:24 GMT

Yup... I want Red Spade as the first product for Domestic... this is because I want to create a top 5 Item for each region. So, no work around for this one?

Sorting in Trellis chart

erichshiino — Tue, 10 May 2011 03:00:11 GMT

I'd say the work around would be the creation of two charts. Each one locked to one region by set analysis.

Then,

The expression of the first would be (I don't know the name of your fields, ok)

SUM { <Region = {International}> Sales}

and

SUM { <Region = {Domestic}> Sales}

Sorting in Trellis chart

hdonald — Fri, 13 May 2011 11:08:33 GMT

Hi,

There might be a way to do this in one Trellis chart depending on how you are calculating your Top 5 - if you can have your Top 5 Rank number as the secondary dimension in the Trellis.

If you also added an expression containing the Item Name (no bar ticked - only 'Values on Data Points') then the rank number would sort the items in the order you want and the extra expression would display the Item name for each bar (you could also tick 'Plot Values inside segments')

If the Rank has to be calculated then add a calculated dimension something like

=if(aggr(rank(sum(Sales)),Origin,Item)<=5,

aggr(rank(sum(Sales)),Origin,Item) )can

Otherwise if you have the Rank Number as a dimension from the script maybe Dual() can be used to sort by a Rank number but display an Item name.

If you post an example doc I'm sure others will contribute more suggestions,

Regards,