topic Re: Selection of work centers in script in QlikView

Selection of work centers in script

Thu, 30 May 2013 06:40:46 GMT

I have a lot of work centers in my file: PM-TECH, PM-PRO, PM-OFF, AM-SLIT, AM-DOCT and many more.

I want to use work center as dimension in a chart but I want to filter out PM-TECH and all that starts with AM.

Can i do like this in my script?

IF([Main WorkCtr]='PM-TECH','PM','AM') as Workcenter

Will it work so it's not counting with PM-PRO and PM-OFF, only PM-TECH and all AM?

Best regards

/Mats

Re: Selection of work centers in script

tresB — Thu, 30 May 2013 06:52:12 GMT

you can use Calculated Dimension in the front end. use expression:

IF([Main WorkCtr] not LIKE 'AM*' or [Main WorkCtr] <>'PM-TECH', [Main WorkCtr])

Thanks.

Re: Selection of work centers in script

oleg_orlov — Thu, 30 May 2013 07:01:31 GMT

Hi!

Try something like that:

Sum ({$<WorkCenter = WorkCenter - {'PM-TECH'} - {"AM*"} >} 1)

Re: Selection of work centers in script

Thu, 30 May 2013 08:16:24 GMT

Hi all and thanks for your (very quick!) answers.

I have tried them all with or without more or less success...

I get something like this in my graph:

but i would like it to be like this:

Just a difference between PM-TECH (PM-PRO and the other PM's should not count) and all AM together.

My expression is clear so i don't want to touch that, it must be done in the script or in the dimension.

/Mats

Re: Selection of work centers in script

Sokkorn — Thu, 30 May 2013 08:21:46 GMT

Hi Mats,

Did you try "Calculated Dimension" yet? In your pie chart use this calculated dimension

=If(WildMatch(Workcenter,'*AM*','AM',

If(WildMatch(Workcenter,'*PM*','PM')))

Regards,

Sokkorn

Re: Selection of work centers in script

Thu, 30 May 2013 08:56:44 GMT

I get an error if i try this

I have tried to put in ,1 and ,0 where the mark is but then my chart is all black.

It looks fine when i do like i described from the start;

([Main WorkCtr]='PM-TECH','PM','AM') as Workcenter

but i im not sure if it's showing the right result.

/Mats

Re: Selection of work centers in script

oleg_orlov — Thu, 30 May 2013 09:04:57 GMT

= if (WildMatch (Workcenter, 'AM*') > 0,

'AM',

if (WildMatch (Workcenter, 'PM*') > 0,

'PM',

'Others'

)

Re: Selection of work centers in script

Sokkorn — Thu, 30 May 2013 09:07:35 GMT

Hi Mats,

Oop sorry my fault.

Use this one

=If(WildMatch(Workcenter,'*AM*'),'AM',

If(WildMatch(Workcenter,'*PM*'),'PM'))

Regards,

Sokkorn

Re: Selection of work centers in script

er_mohit — Thu, 30 May 2013 09:23:44 GMT

Try this

if(pick(WildMatch(Workcenter,'*AM*'),'AM') or

pick(WildMatch(Workcenter,''PM-TECH'),'PM'),Workcenter)

Re: Selection of work centers in script

Thu, 30 May 2013 10:11:56 GMT

Hi and thx.

This works but the problem is that all PM is counted. It is just the workcenter with the name 'PM-TECH' that should be accounted for.

/Mats

Re: Selection of work centers in script

oleg_orlov — Thu, 30 May 2013 10:14:58 GMT

= if (WildMatch (Workcenter, 'AM*'),

'AM',

if (Workcenter = 'PM-TECH'),

'PM',

'Others'

)

or without Others:

= if (WildMatch (Workcenter, 'AM*'),

'AM',

if (Workcenter = 'PM-TECH'),

'PM'

)

Re: Selection of work centers in script

Sokkorn — Thu, 30 May 2013 10:18:24 GMT

Hi Mats,

Can you try this again

=If(WildMatch(Workcenter,'*AM*'),'AM',

If(Workcenter='PM-TECH','PM',Null()))

Regards,

Sokkorn