Expression Help

[#1]

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.

[robert_mika]

Could you share your data and desired results?

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[MK_QSL]

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

or

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

[#4]

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

[pratap6699]

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

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