topic Re: Expression Needed in QlikView

Expression Needed

bharatkishore — Thu, 21 Jul 2016 06:46:04 GMT

Hi All,

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

a others,

b others,

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

Re: Expression Needed

tresB — Thu, 21 Jul 2016 06:56:37 GMT

May be like:

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

or,

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

Re: Expression Needed

er_mohit — Thu, 21 Jul 2016 06:58:23 GMT

Try this

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

Re: Expression Needed

bharatkishore — Thu, 21 Jul 2016 06:58:45 GMT

Hi Tresesco,

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

Re: Expression Needed

Thu, 21 Jul 2016 07:00:53 GMT

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

Re: Expression Needed

tresB — Thu, 21 Jul 2016 07:03:04 GMT

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

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

or,

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

Re: Expression Needed

philipp_ebner — Thu, 21 Jul 2016 07:03:35 GMT

Hi Bharat,

Try this:

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

Regards philipp

Re: Expression Needed

Thu, 21 Jul 2016 07:05:08 GMT

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

Re: Expression Needed

bharatkishore — Thu, 21 Jul 2016 07:05:57 GMT

Thanks a lot...

Re: Expression Needed

bharatkishore — Thu, 21 Jul 2016 07:06:24 GMT

thanks a lot