topic Edit Expression in QlikView

Edit Expression

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

I'm trying to edit the following expression to include "Sum({<[Year]={$(=(Only(Year)))}>}(Actaul_Amount)) "

Sum({$<HCOEdetail={'Revenue'}>}Actaul_Amount)/Sum(EjFTE)

How do I combine these so that it filters the year and the revenue divided by FTE?

Re: Edit Expression

vishsaggi — Mon, 13 Feb 2017 14:41:11 GMT

Try this?

Sum({$<HCOEdetail={'Revenue'}, [Year]={ $(=Only(Year)) } >} Actaul_Amount)/Sum(EjFTE)

Re: Edit Expression

vishsaggi — Mon, 13 Feb 2017 14:43:44 GMT

Hold on why you want the expr Only(Year) in your set. You expr of sum/sum(fte) will be calculated based on your selections right? What is that you are trying to get ?

Re: Edit Expression

fanninam — Mon, 13 Feb 2017 18:24:51 GMT

It's a line graph with selected year and previous year for the two lines. Your solution worked. Thank you very much!