topic Re: Help with formula in QlikView

Help with formula

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to write a formula that will give me the following detail for each of the two columns Svc Group and Svc line.

I only want to pull in the following from Svc Group:

And I only want to pull in the following from Svc Line:

Transaction

FRM

RC Other

Technology Enablement

Can anyone please help

Re: Help with formula

sunny_talwar — Thu, 31 Mar 2016 10:23:06 GMT

May be try this expression:

Count({<[Svc Group] = {'MC', 'RC', 'TR'}, [Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])

Re: Help with formula

sunny_talwar — Thu, 31 Mar 2016 10:24:23 GMT

Or this, if this is not and condition, but an or condition (show this or show that)

Count({<[Svc Group] = {'MC', 'RC', 'TR'}>+<[Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])

Re: Help with formula

Chanty4u — Thu, 31 Mar 2016 10:24:23 GMT

load *,

........

from table

Where svcgroup='mc','rc','tr' and Svcline='

'Transaction',

'FRM',

'RC Other',

'Technology Enablement';

Re: Help with formula

Thu, 31 Mar 2016 12:27:49 GMT

If I were to go this route I would do this in the edit script correct?

Would this limit svc group and svc line to only those that I've selected throughout the file. So any graphs or charts that I use it will only display svcgroup='mc','rc','tr' and Svcline='

'Transaction',

'FRM',

'RC Other',

'Technology Enablement';

Re: Help with formula

Thu, 31 Mar 2016 12:39:21 GMT

sunindia I notice that after Count you have {< and at the end of your formula you have >}. Why do you have these in there?

Re: Help with formula

sunny_talwar — Thu, 31 Mar 2016 13:26:44 GMT

This is a set analysis syntax. For more information on set analysis, it would be good to spend some time on the attached document