Use Expression Label in Calculated dimension

guyvermeiren — Wed, 16 Mar 2011 15:58:00 GMT

Hello,

Can I use the expression label in the formula of a calculated dimension ??

Let's say that I calculated the rank in the expression with label "Position". Can I use the name "Position" then in a calculated dimension ?

Thanks

Kind regards,

Guy

Use Expression Label in Calculated dimension

boorgura — Wed, 16 Mar 2011 16:00:48 GMT

I dont think you can use the label direcly.

But, you can use the same calculation using aggregation function.

Use Expression Label in Calculated dimension

guyvermeiren — Wed, 16 Mar 2011 16:19:17 GMT

Thanks Rocky,

But the goal of my question is the next. I think this is really difficult.

I want to limit my table to a Top 10 what isn't difficult but I want a top 10 for my customers who are advancing the most and had a turnover last year that was above a certain limit.

These are the two expressions that I try to combine in my calculated dimension but how do I say in my formula that I first want to limit the list to customers with a certain turnover and then only show the top 10 (by rank and "Suppress when value is Null" ).

Expression 1: limit turnover

Expression 2: Rank on evolution

=If(aggr(sum({$<[COPA.Fiscal Year]= {$(=max([Calendar.Year])-1)},COPA.Period= {'*'} >} [COPA.Niko Act Gross Sales incl Projects Rebates NL/FR]), [GeneralPayerMasterData.Customer Name&Code])>15000,[GeneralPayerMasterData.Customer Name&Code],null())

=If(aggr(rank(( Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]))} , [COPA.Period]= {">$(=min([Calendar.Month])-1)<$(=max([Calendar.Month])+1)"} >} [COPA.Niko Act Gross Sales incl Projects Rebates NL/FR] )/ Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]-1))} , [COPA.Period]= {">$(=min([Calendar.Month])-1)<$(=max([Calendar.Month])+1)"} >} [COPA.Niko Act Gross Sales incl Projects Rebates NL/FR] ) )-1),[GeneralPayerMasterData.Customer Name&Code])<=10, [GeneralPayerMasterData.Customer Name&Code],Null())

It would be great if someone could help me.

Thanks

Kind regards,

Guy

topic Use Expression Label in Calculated dimension in QlikView

Use Expression Label in Calculated dimension

Use Expression Label in Calculated dimension

Use Expression Label in Calculated dimension