topic MultiBox in QlikView

MultiBox

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have Country,Item,Product,Stcode,Sales,Purchase as fields

i have a multi box with Country, Item.Product, list box with Stcode and a Pivot table with Item, Product, Sales, Purchase.

Here for the Product field in multibox i am getting 7 records, but in the chart i am getting 13 products For the Country Selection UK and Stcode 0.

because I have used Sum({<Stcode=>}Purchase), due to this product values are not in sync between Chart and MultiBox, so how can i show the 13 values in the multibox Product field.

Load Script:

Directory;

LOAD Country,

Item,

Product,

Stcode,

Sales

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Directory;

LOAD Country,

Item,

Product,

Num(Purchase,'#,##0') AS Purchase

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

Purchaseexpression: sum({<Stcode=>}Purchase)

Sals Expression: Sum(Sales)

can any one help me on this.

Thank you!

John

Re: MultiBox

sunny_talwar — Thu, 28 Jul 2016 11:53:13 GMT

May be use a calculated expression for the multibox:

Aggr(Only({<Stcode = >} Product), Product)

Re: MultiBox

Thu, 28 Jul 2016 11:55:42 GMT

Thanks Sunny for the Prompt response,

above expression it is not working.

Regards,

John

Re: MultiBox

sunny_talwar — Thu, 28 Jul 2016 11:57:12 GMT

Would you be able to share the sample application you are working with?

Re: MultiBox

Thu, 28 Jul 2016 12:02:18 GMT

PFA.

Thanks

John