topic Re: problems with only syntax in expression in QlikView

problems with only syntax in expression

Wed, 15 Feb 2017 08:37:01 GMT

Dear experts,

I was trying to implement an only function in my expression, but it does not seem to be working. can anyone please help me with this ?

This problem was also stated in the forum earlier on in that link.

The expression is as of such

Sum({$<BDF_Type={"*profit*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash) / Sum({$<BDF_Type={"*revenue*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash)

I am trying to restrict the year value as it also calls the 2015 from the month field. Cheers

Kind regards,

Royce

jonathandienst — Wed, 15 Feb 2017 09:00:06 GMT

You just need Year = {2015} in your expression

Sum({$<

BDF_Type={"*profit*"},

YEAR = {2015},

>} cash

) /

Sum({$<

BDF_Type={"*revenue*"},

YEAR = {2015},

>} cash

)

Wed, 15 Feb 2017 09:02:54 GMT

Dear Jonathan,

as stated in the link, you will see the problem i have by just using 2015

Thanks for helping !