Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Expression Needed

Hi All,

I am having an logistic field and in that i have the data like,

a,

a others,

b,

b others,

c

c others.

Now i need to calculate only the fields are with others..

i.e. sum(if([logistic model] = 'aothers',if([logistic model]='bothers',if([logistic model]='c others'[lead count]))))

Thanks,

Bharat

1 Solution

Accepted Solutions
Not applicable

sum({<[logistical model]={'aothers','bothers','cothers'}>} [lead count])

View solution in original post

9 Replies
tresesco
MVP
MVP

May be like:

Sum(if( Wildmatch([logistic model], '*others*'), [lead count])

or,

Sum({<[logistic model]={ '*others*'}>} [lead count])

er_mohit
Master II
Master II

Hi

Try this

sum({<[logistic model] ={'*others'}>}[lead count])

bharatkishore
Creator III
Creator III
Author

Hi Tresesco,

I have multiple others like d others,e others , h others.. but i needed onlysum of aothers,bothers,cothers not any others.

Not applicable

Hi Bharat,

Try this,

sum({<T={'*Others*'}>}Value)

// Here, I took inline table for an example

E.g

Load * Inline

[

T, Value

A, 10

A Others, 45

B, 20

B Others, 40

];

Regards,

Brijesh

tresesco
MVP
MVP

May be using single character wildcard '?', like:

Sum(if( Wildmatch([logistic model], '?others'), [lead count])

or,

Sum({<[logistic model]={ '?others'}>} [lead count])

philipp_kunz
Partner - Creator II
Partner - Creator II

Hi Bharat,

Try this:

=count(if(WildMatch(A,'*others*'), A))

Regards philipp

Not applicable

sum({<[logistical model]={'aothers','bothers','cothers'}>} [lead count])

bharatkishore
Creator III
Creator III
Author

Thanks a lot...

bharatkishore
Creator III
Creator III
Author

thanks a lot