Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Collapse Table

Hi Experts,

I have a table with Sales Order Positions, and i have a flag if the position is in Delay or not.

Order     Pos     Delay

991          10     1

991          20     0

991          30     0

888          10     0

888          20     0

888          30     0

I should have a chart with the Sales Order without Position, and,if at least one position is 1, all Order is 1.

if all order is 0 the Order Record is 0.

Order     Delay

991          1

888          0

Can you help me ?

3 Replies
Not applicable
Author

The solution is near.

every Order Can has several position in Delay.

Order     Pos     Delay

991          10     1

991          20     1

991          30     0

888          10     0

888          20     0

888          30     0

666          10     1

666          20     1

666          30     1   

But in my chart I want only e chart that gives me only a flag. For examble

Order     Delay

991          1

888          0

666          0

Not applicable
Author

Errata Corrige

But in my chart I want only e chart that gives me only a flag. For examble

Order     Delay

991          1

888          0

666          1

whiteline
Master II
Master II

Order     Pos     Delay

991          10     1

991          20     1

991          30     0

888          10     0

888          20     0

888          30     0

666          10     1

666          20     1

666          30     1

Hi.

Don't understand how have you got 1 for 991 'cause there are both 0 and 1.

You could create collapsed table in script with group by statement (look at help).

You could also just create a 'table box' with two fields  Order and Delay.