topic Re: Static Scale Expression based on Group Dimension in QlikView

Static Scale Expression based on Group Dimension

Sun, 05 Jun 2011 19:53:36 GMT

How would I vary a static step expression based on a Cyclic Dimension displayed.

Cyclic Dimension Values: Product, Country, SalesRep

Expression: sum(Sales).

If the dimension is Product, static step should be 50000

If the dimension is SalesRep, static step should be 100000

If the dimension is Country, static step should be 200000

Thanks in advance for any thoughts.

Re: Static Scale Expression based on Group Dimension

Sun, 05 Jun 2011 20:47:33 GMT

Hi Tod,

if your group is named ProductSalesRepCountry the expression will be:

=if(GetCurrentField(ProductSalesRepCountry) = 'Product',50000,
  if(GetCurrentField(ProductSalesRepCountry) = 'SalesRep',100000,
    if(GetCurrentField(ProductSalesRepCountry) = 'Country',200000)))

Hope this helpes!

Stefan

Static Scale Expression based on Group Dimension

Sun, 05 Jun 2011 21:57:06 GMT

THANK YOU ! man - I just could not get that right.