topic Re: Problem set analysis? in QlikView

Problem set analysis?

Wed, 07 Nov 2012 09:40:54 GMT

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

Re: Problem set analysis?

Wed, 07 Nov 2012 09:47:36 GMT

Hi,

I don't know if I understand you clearly ,

Can you attacch a qvw ?

Regards,

Yigal

Re: Problem set analysis?

Wed, 07 Nov 2012 09:59:43 GMT

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

Re: Problem set analysis?

perumal_41 — Wed, 07 Nov 2012 10:19:51 GMT

Try this expression

Aggr(only({$<

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

Re: Problem set analysis?

somenathroy — Wed, 07 Nov 2012 10:48:45 GMT

Hi,

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

Regards,

Som

Re: Problem set analysis?

Wed, 07 Nov 2012 10:48:59 GMT

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

Re: Problem set analysis?

perumal_41 — Wed, 07 Nov 2012 11:07:03 GMT

Hi,

you mark correct ans for helpful for others

Re: Problem set analysis?

Wed, 07 Nov 2012 12:06:20 GMT

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!

Re: Problem set analysis?

Wed, 07 Nov 2012 12:45:33 GMT

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

Re: Problem set analysis?

perumal_41 — Wed, 07 Nov 2012 12:49:20 GMT

Hi,

Try this expression

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

Re: Problem set analysis?

Wed, 07 Nov 2012 13:01:40 GMT

it's ok with the only but i must put the set in the dimension (for operation) and not in the expression, so with that the dimension will put many row and it's work

THANK YOU Perumal for your answer and every body for your attention