Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

alan_grn
Contributor

Set analysis help

I am trying to do the following. COuld you please help with the set analysis.

IF FIELD1 value <> 'text value' then sum fieldvaue2 where fieldvlaue3 <> 'a value'

1 Solution

Accepted Solutions
Not applicable

Set analysis help

HI,

Try this:


If(Field1 <> 'text value', sum({$<Field3 -= {'a value'}>} Field2))


Regards

2 Replies
Not applicable

Set analysis help

HI,

Try this:


If(Field1 <> 'text value', sum({$<Field3 -= {'a value'}>} Field2))


Regards

MVP
MVP

Set analysis help

Hello,

Just going one step further, I'd include all conditional in set analysis. It shuould work and perform better

sum({$< Field1 -= {'text value'}, Field3 -= {'a value'} >} Field2)


Regards.

Community Browser