Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

el_lloydie
New Contributor III

Expression Help

Hi guys,

Me again!

I have the following expression that a colleague has been using:

Sum({<[Pay Status - Code]={'P'}>}[$(=CTName)])

How do I amend it properly (I've tried, and I'm getting weird and wonderful) to pull everything back, and not just those marked P?

Thanks in advance,

Gareth

1 Solution

Accepted Solutions
MVP
MVP

Re: Expression Help

May be this

Sum([$(=CTName)])

3 Replies
devarasu07
Honored Contributor II

Re: Expression Help

Hi,

measure is variable   [$(=CTName)]) ? if not just use it CTName

=SUM({$<[Pay Status - Code] -= {"P*"}>} [$(=CTName)]) )

or

=SUM({$<[Pay Status - Code] = {"*"} - {"P*"}>} [$(=CTName)]) )

agigliotti
Honored Contributor II

Re: Expression Help

what's the problem ??

MVP
MVP

Re: Expression Help

May be this

Sum([$(=CTName)])