topic Re: Multibox format in QlikView

Multibox format

Anonymous — Thu, 01 Mar 2018 07:55:12 GMT

Hi,

I am trying to create a multibox to show the info for the various fields shown below:

Customer

Material

Description

Supplier

Offered

Ordered

The box display information correctly for the fields except "Ordered" and "Ordered". I have attached screenshot of the QV done and sample of the data file.

Can someone please explain what have i done wrong and the correct way to display the information. I'm new to this and trying out to have a better understanding.

Thanks

David

Re: Multibox format

isingh30 — Thu, 01 Mar 2018 17:42:03 GMT

Please share your app.

Thank you!

Re: Multibox format

Anonymous — Fri, 02 Mar 2018 01:02:08 GMT

Hi Ishtdeep,

Thanks for replying, i cant find anything icon to attach my qvw to let you see. The "Action" button does not work for me. Please advise.

David

Re: Multibox format

Anonymous — Fri, 02 Mar 2018 01:15:44 GMT

Hope you can see it, thanks

Re: Multibox format

vishalmanu — Fri, 02 Mar 2018 01:57:16 GMT

Hello david lim,

Your applications looks fine to me. For the fact that the all the fields in your data has same value except for Ordered field. It contains two different values '0' & '1'. That's the reason the value for Ordered in Multi box is not appearing by default.

You need to select by drop down button.

Hope this helps.

Thanks

Vishnu T

Re: Multibox format

vishalmanu — Fri, 02 Mar 2018 02:01:41 GMT

Have a look at the attached screen shot. !

Hope this helps!!

Thanks

Vishnu T

Re: Multibox format

vishsaggi — Fri, 02 Mar 2018 02:04:34 GMT

I dont find anything wrong with your multibox. What is the issue. You are seeing a circle becos you have two distinct values for your Ordered field so when you click on it it will show 0 and 1 which is right. Am i missing something?

For all other fields it is showing distinct values accordingly.

Sales Organization	Customer	Description	Supplier	Material	Offered	Ordered
BEVS	MITSUBISHI HEAVY INDUSTRIES MECHATR	BEARING 51406	§6	1075002	1	0
BEVS	MITSUBISHI HEAVY INDUSTRIES MECHATR	BEARING 51406	§6	1075002	1	1

Re: Multibox format

Anonymous — Fri, 02 Mar 2018 02:11:14 GMT

Hi Vishwarath,

Yes, you are right on point. I'm not sure on how to display the 0 and 1 in the Ordered field correctly. Is there a way i can display the values?

Thanks

Re: Multibox format

vishsaggi — Fri, 02 Mar 2018 02:59:50 GMT

Not sure if we have that facility in Multibox, you might have to use some kind of Pivot to display that.

Re: Multibox format

Anonymous — Fri, 02 Mar 2018 03:04:59 GMT

Sure, i will try pivot to see if it works for me.

Thanks