topic Re: Collapse Table in QlikView

Collapse Table

Fri, 26 Oct 2012 12:25:47 GMT

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 ?

Re: Collapse Table

Fri, 26 Oct 2012 13:01:59 GMT

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

Re: Collapse Table

Fri, 26 Oct 2012 13:02:38 GMT

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

Re: Collapse Table

whiteline — Fri, 26 Oct 2012 18:41:58 GMT

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.