Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Static Scale Expression based on Group Dimension

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.

TD

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

Not applicable
Author

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