topic Front end table not affected by selection in QlikView

Front end table not affected by selection

Fri, 07 Jun 2013 07:59:00 GMT

I want to create a table in the front end , where its not affected by a selection.

So for example: I have customers with the following back orders:

Customer Qty on Back Order

Customer A: 20

Customer B: 50

Customer C: 80

Total 150

So if I have a list box of of Customers and I select customer A, I want a table to show both 20 and total of 150. (as per below)

Customer Qty on Back Order Total Qty on Back Order

Customer A 20 150

Basically, how do I do the scripting to display total qty of 150.

kind regards

Nayan

Re: Front end table not affected by selection

Gysbert_Wassenaar — Fri, 07 Jun 2013 08:02:23 GMT

Use as expression in your table sum({<Customer=>} [Qty on Back Order]) for calculating the total qty on back order.

Re: Front end table not affected by selection

swuehl — Fri, 07 Jun 2013 08:16:51 GMT

Try

=$(=sum({<Customer= >} [Qty on Back Order]) )

to evaluate the expression in the TOTAL context.

Or, to ignore all selections:

=$(=sum({1} [Qty on Back Order]) )

Re: Front end table not affected by selection

Fri, 07 Jun 2013 08:30:21 GMT

Hi Gysbert

It worked. Thanks. Lets say now the qty on back order is for specific items: So if we expand, for example:

Customer Item Qty on Back Order

Customer A:

Apples 5

Bananas 10

Pears 5

Customer B: Apples 20

Bananas 30

Customer C:

Apples 40

Bananas 30

Pears 10

So if, we have the same customer A selection, I want it to display the following:

Customer Item Qty on Back Order Total Qty on Back Order

Customer A Apples 5 65

Bananas 10 70

Pears 5 15

Now, for the Total Qty on Back order , how do i do the formula. The one that you have given me above , for each line , it displays 150.

kind regards

Nayan

Re: Front end table not affected by selection

Fri, 07 Jun 2013 09:21:20 GMT

Hi Gysbert

It worked. Thanks. Lets say now the qty on back order is for specific items: So if we expand, for example:

Customer Item Qty on Back Order

Customer A:

Apples 5

Bananas 10

Pears 5

Customer B: Apples 20

Bananas 30

Customer C:

Apples 40

Bananas 30

Pears 10

So if, we have the same customer A selection, I want it to display the following:

Customer Item Qty on Back Order Total Qty on Back Order

Customer A Apples 5 65

Bananas 10 70

Pears 5 15

Now, for the Total Qty on Back order , how do i do the formula. The one that you have given me above , for each line , it displays 150.

kind regards

Nayan

Re: Front end table not affected by selection

Gysbert_Wassenaar — Fri, 07 Jun 2013 09:50:26 GMT

Try sum(aggr(sum({<Customer=>}[Qty on Back Order]),Item))