Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem set analysis?

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

1 Solution

Accepted Solutions
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

Try this expression

Aggr(only({$<

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

View solution in original post

10 Replies
Not applicable
Author

Hi,

I don't know if I understand you clearly ,

Can you attacch  a qvw ?

Regards,

Yigal

Not applicable
Author

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
Partner - Specialist II
Partner - Specialist II

Hi

Try this expression

Aggr(only({$<

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

somenathroy
Creator III
Creator III

Hi,

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

Regards,

Som

Not applicable
Author

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) firstattachement.png

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

secondattachement.png

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

Thank you for your time

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

you mark correct ans for helpful for others

Not applicable
Author

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:

pbjours.png

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!

Not applicable
Author

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
Partner - Specialist II
Partner - Specialist II

Hi,

Try this expression

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