Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

vgodoy78
New Contributor

Create an Expression

Hello,

I am new to QlikView and I am trying to do the following...

I want to create a chart where the expression only calculates payments if the dimension called Pay Code is equal to 17 or 18.

=IF(AND(PAYCODE='17',PAYCODE='18'),SUM(TRANSACTION_PAYMENT),NULL)


What is the appropriate syntax for this expression?


thanks!

1 Solution

Accepted Solutions
vikasmahajan
Honored Contributor III

Re: Create an Expression

Please try this  SUM( {< PAYCODE={'17','18'} >} TRANSACTION_PAYMENT)

4 Replies
vikasmahajan
Honored Contributor III

Re: Create an Expression

Please try this  SUM( {< PAYCODE={'17','18'} >} TRANSACTION_PAYMENT)

awhitfield
Esteemed Contributor

Re: Create an Expression

Hi Varinia,

please see the attached worked example using set analysis in the expression.

HTH Andy

vgodoy78
New Contributor

Re: Create an Expression

Thanks!

This worked, I really appreciate your help.

vikasmahajan
Honored Contributor III

Re: Create an Expression

can you mark correct answer if it works perfectly.

Vikas

Community Browser