Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Master

## How to add condition = (SEGMENT <> 'Related Coy') , into my SET expression ?

Hi All

My Table 2 Expression is working fine from Sunny :-

Sum({<aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

I need to insert a new condition into above expression , Which is SEGMENT not equal to Related Company. which is look like below :-

(SEGMENT <> 'Related Coy', SEGMENT)

Sum((SEGMENT <> 'Related Coy'),{<aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

I try the above expression , it is not working , Hope some one can advise.

I expected Table 2 Total = 383,409

Paul

1 Solution

Accepted Solutions

Perhaps this

Sum({<aging = {'>=180'},SEGMENT -= {'Related Coy'} >} da3_total  * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
5 Replies
Master
Author

my qvw

Anonymous
Not applicable

you Need to put the new Expression inside {<

try this:

Sum({<SEGMENT-={'Related Coy'},aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

Master

use -= instead of <> in Your Expression Sum({<SEGMENT -={ 'Related Coy'}.......

Perhaps this

Sum({<aging = {'>=180'},SEGMENT -= {'Related Coy'} >} da3_total  * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Master
Author

Hi All

Many thank , it work fine now.

Paul

Community Browser