topic Re: Expression to use all values in QlikView

Expression to use all values

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

Hi,

I have an expression that calculates the billable wage per location or team id however I will like to modify it to calculate for the entire company meaning all locations and team ids considered regardless if the user selects a specific location. This is the expression below

=sum({$<metric_name={'Billable Wages'},metric_grouping={'OT'} ,group_name=p(group_name), team_id=,LocationDescription=, $(vset12Months_Modifier) >} metrictotal)

/ sum({<group_name=p(group_name), team_id=,LocationDescription=, $(vset12Months_Modifier) >}hours_units)

I tried to remove the team_id=, and locationDescription=, but it is still calculating the same thing as the above expression. The goal is I also have a bar graph with the expression above so I will like the line graph expression to calculate for the entire company. Any help will be much appreciated.

Thank you

Re: Expression to use all values

albertovarela — Wed, 20 Jun 2018 22:43:19 GMT

I suggest you to take a look at the TOTAL qualifier...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/define-aggregation-scope.htm

What does the TOTAL qualifier do?

Re: Expression to use all values

vupen — Thu, 21 Jun 2018 05:38:26 GMT

Replace $ in the expression with 1:

=sum({1<metric_name...

This way, the expression would consider the total data set to compute the expression, disregarding any selections made.

Re: Expression to use all values

taylor_jesse — Thu, 21 Jun 2018 15:11:16 GMT

Hi,

I tried it and the result did not change