Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
fanninam
Creator
Creator

Stagnant Fields

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])

1 Reply
sergio0592
Specialist III
Specialist III

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])