topic Re: Troubleshoot Expression in QlikView

Troubleshoot Expression

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

Hi I have the expression below that I am trying to make it stay constant no matter what the user selects. I used "1" but the line for the expression still adjusts when the user make a selection.

=sum({1<metric_name={'Billable'}, metric_grouping={'OT'}, $(vset12Months_Modifier)>} metric total)

/ sum($(vset12Months_set) hours_units)

Any suggestions on how to make this expression constant no matter what the user selects.

Thank you

Re: Troubleshoot Expression

stabben23 — Thu, 05 Jul 2018 14:11:43 GMT

Maybe try With this.

=sum({1<metric_name={'Billable'}, metric_grouping={'OT'}, $(vset12Months_Modifier)>} metric total)

/ sum({1} $(vset12Months_set) hours_units)

Re: Troubleshoot Expression

taylor_jesse — Thu, 05 Jul 2018 14:16:29 GMT

Thank you for your help. The line for the expression still adjusts based on user selection. The values on the y axis changes as well. I will like this expression to stay the same no matter what.

Re: Troubleshoot Expression

vishsaggi — Thu, 05 Jul 2018 15:01:33 GMT

I think its because of the variables. So you want to exclude the values coming from Variable too. Right?

Re: Troubleshoot Expression

taylor_jesse — Thu, 05 Jul 2018 15:05:20 GMT

The variable is for 12 month period. I will like to include the variable to calculate a 12 month time period.

Re: Troubleshoot Expression

vishsaggi — Thu, 05 Jul 2018 15:43:05 GMT

Ok so the Period will change based on your selections so which 12 months you want to make it static, like current 12 months?

Re: Troubleshoot Expression

taylor_jesse — Thu, 05 Jul 2018 15:51:33 GMT

Yes 12 current month. Below is the definition for the variable.

vset12Months_Modifier = MonthYear= MonthYear={">=$(=date(addmonths(max(MonthYear),-11),'MMM-YYYY')) <=$(=max(MonthYear))"}

vset12Months_Set = {$<MonthYear={">=$(=date(addmonths(max(MonthYear),-11),'MMM-YYYY')) <=$(=max(MonthYear))"}>}