Problem set analysis?

[#1]

Hello everybody,

I have a problem that i can't resolve!

I'm working on a report summarizing the operations order.

For each operation of a command there is a duration of operation associated ("Durée" in the attach file).

I would like the user to enter a maximum duration, in this case orders with operation time exceeds this variable will be eliminated.

With the set analysis I can remove operation in a period longer than the variable, but not the entire order!

Anyone have an idea?

Thank you in advance

[#2]

Hi,

I don't know if I understand you clearly ,

Can you attacch  a qvw ?

Regards,

Yigal

[#3]

Sorry Yigal it's confidential data and sorry for my bad english!

My problem is that i know how to delete the row of operations who are bigger than the variable:

only({$<

duration={"<=$(=vduration)"}>} Operation)

It' ok this set analysis delete the operation bigger than vduration but i want delete all the order (and the operations associated) --> But can i do set analysis in dimension?

Thank a lot

[perumal_41 · Accepted solution]

Hi

Try this expression

Aggr(only({$<

duration={"<=$(=vduration)"}>} Operation),Operation)

[somenathroy]

Hi,

If chart contains multiple expression, then the set, ({$<duration={"<=$(=vduration)"}>} needs to be included in every expression.

Regards,

Som

[#6]

It works it takes me orders with no operations over the variable.

But the display when the command contains only one operation I have a good display (first attachment)

but when it contains more than one operation the table shows a single line with empty fields (second attachment )

I wish that table display all the lines of operations of this command!

Thank you for your time

[perumal_41]

Hi,

you mark correct ans for helpful for others

[#8]

Sorry but i have to eat sometimes!

It doesn't work, i have try to include in all expression the set but it doesn't work.

let see:

In the second table I have the great order ("Commandes"), the great year of order ("Année commande") and the great number of piece of part ("Nombre de pièce") it's normal because all the rows of that are the same. But i don't arrive to have all the operation ("Code opération")!!!

My set analysis:

in dimension:     Order==Aggr(Only({$<duration={"<=$(=vduration)"}>}order),operation)

in expression:     year of order=Aggr(Only({$<duration={"<=$(=vduration)"}>}year of order),operation)

                         number of piece=Aggr(Only({$<duration={"<=$(=vduration)"}>}number of piece),operation)

                         operation=Aggr(Only({$<duration={"<=$(=vduration)"}>}operation),operation)

I don't understand where is the mistake?

Thank a lot everybody!

[#9]

Hello Perumal,

It doesn't work i think it's because in my dimension expression there is the "only" (Aggr(Only({$<duration={"<=$(=vduration)"}>}order),operation))

So the table will have only one row!! How can i put set analysis and have the order (so not sum,avg...)

Thank you Perumal

[perumal_41]

Hi,

Try this expression

Count({$<duration={"<=$(=vduration)"}>}order)