Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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])

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