Stagnant Fields

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to get the correct syntax so that two specific fields will stay stagnant. I need Site5 and BU5 to stay stagnant.

This is the original statement:

SUM({<[Metric Name] = {'Voluntary Turnover Total'}>}[Vol Terms/ Compa/ Promotions]) / SUM({<[Metric Name] = {'Voluntary Turnover Total'}>}[Average Hdct])

I tried the following but it ignores the Site5 and BU5:

SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 = {'ESA'},BU5 = {'All ESA'}>}[Vol Terms/ Compa/ Promotions]) / SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 = {'ESA'},BU5 = {'All ESA'}>}[Average Hdct])

Re: Stagnant Fields

sergio0592 — Thu, 04 Jan 2018 18:51:15 GMT

For ignore selevtion on Site5 and BU5 filds , try with :

SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 =,BU5 = >}[Vol Terms/ Compa/ Promotions]) / SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 = ,BU5 = >}[Average Hdct])

topic Re: Stagnant Fields in QlikView

Stagnant Fields

Re: Stagnant Fields