Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

problems with only syntax in expression

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

Duplicate values in bar Chart

2 Replies
MVP
MVP

Re: problems with only syntax in expression

You just need Year = {2015} in your expression

Sum({$<

  BDF_Type={"*profit*"},

  YEAR = {2015},

  >} cash

) /

Sum({$<

  BDF_Type={"*revenue*"},

  YEAR = {2015},

  >} cash

)

Highlighted
Not applicable

Re: problems with only syntax in expression

Dear Jonathan,

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

Thanks for helping !

Community Browser