set analysis

[Dolly123]

i need top 3 segments with last 6 month (rolling) in set analysis

[Mark_Little]

HI

You will need to share a little more information. Where are you currently i.e. What set analysis is in the chart shown? What have you tired? where are you stuck? 

[Dolly123]

=sum({< FiscalYear=, FiscalMonthName=, Date={"$(='>='& Date(Monthstart(max(Date),-6))&'<'&Date(Monthstart(max(Date))))"}>}[Capacity (TR/HP)])

this set is for 6 months but i want top 3 also in this set analysis in qliksense

[salonicdk28]

Hi, write a calculated dimension for top 3 segments like below along with your above expression in measure-

aggr(if(rank(Sum(Capacity (TR/HP)<=3,segment),segment)

[Dolly123]

i am getting error

[Dolly123]

i want to show same chart as last 6 month also how both can implement

[salonicdk28]

You haven't closed the sum bracket, try this once

aggr(if(rank(Sum([Capacity (TR/HP)]))<=3,segment),segment)

[salonicdk28]

Rank and sum bracket need to be closed, that's why getting an error there

[Dolly123]

same error

[Dolly123]

I do but no data present in chart and also i need last 6 month with top 3 segments