Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bharatkishore
Contributor 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

Re: Expression Needed

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

9 Replies
MVP
MVP

Re: Expression Needed

May be like:

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

or,

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

Highlighted
er_mohit
Honored Contributor II

Re: Expression Needed

Hi

Try this

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

bharatkishore
Contributor III

Re: Expression Needed

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

Re: Expression Needed

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

MVP
MVP

Re: Expression Needed

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

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

or,

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

philipp_kunz
Contributor

Re: Expression Needed

Hi Bharat,

Try this:

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

Regards philipp

Not applicable

Re: Expression Needed

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

bharatkishore
Contributor III

Re: Expression Needed

Thanks a lot...

bharatkishore
Contributor III

Re: Expression Needed

thanks a lot

Community Browser