topic Expression Help in QlikView

Expression Help

Wed, 01 Jul 2015 13:45:57 GMT

Hello,

I am looking to return a set of values that have an Transaction Type (dimension) = 'Airfare' and that the on the transaction was Spend > 600 within a a text object. I am getting caught up on the expression right now.

Re: Expression Help

robert_mika — Wed, 01 Jul 2015 13:57:21 GMT

Could you share your data and desired results?

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Expression Help

MK_QSL — Wed, 01 Jul 2015 13:59:12 GMT

=COUNT({<[Transaction Type] = {'Airfare'}, Speed = {">60"}>}Value)

=SUM({<[Transaction Type] = {'Airfare'}, Speed = {">60"}>}Value)

Re: Expression Help

Wed, 01 Jul 2015 14:02:57 GMT

Thanks Manish that should do it, still working on my set analysis.

Re: Expression Help

pratap6699 — Wed, 01 Jul 2015 16:25:36 GMT

=sum({$<type={'airfare'},speed={'>600'}>}planes)

it returns the total planes which contain only airfare type with their speed morethan 600