topic Help with MULTI BOX in QlikView

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 09:39:42 GMT

Hello,

I have a MULTI BOX with various selection criteria.

One of the selections is called CUSTOMER SCANNING VERSION, the end user can then select from the following

10.33

10.331

10.333

10.334

10.3318

10.51

10.52

10.525

10.529

10.5214

10.5218

All of these fields are needed, but i would like to make the end user experience easier by grouping all 10.33 together and 10.52 togaether.

Meaning that the end user can just click on 10.33 which will display all data relating to 10.33, 10.331, 10.333, 10.334 and 10.3318.

Can anyone help me do this please?

Help with MULTI BOX

Fri, 23 Jul 2010 09:55:09 GMT

hI,

You could make a change in scrip while loading as under

= MID( ID, 1 , 4) AS MODID

What this does is that it makes the ID no as a 2 decimal number and this will solve your problem

Help with MULTI BOX

Anonymous — Fri, 23 Jul 2010 09:56:17 GMT

Here's an example on how to create a second field to use for selections which will be associated with the detailed field.

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 10:25:43 GMT

Sorry, i made a mistake, There are no decimal points in the version numbers.

After looking at your attached example, and trying that in my script, it displayed .00 after every version number.

How can i do it without decimals?

Help with MULTI BOX

nathanfurby — Fri, 23 Jul 2010 10:27:34 GMT

What do your actual version numbers look like?

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 10:31:31 GMT

Sorry, they loom like

1033

10331

10333

10334

103318

1051

1052

10525

10529

105214

105218

Sorry to mess you all about 😞

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 10:35:19 GMT

And this is the part of my script..

LOAD

[Cust Code]

AS %LkDealReportTransactionCustomer

[Cust Status]

[Cust Name]

Customer

[Cust Type]

BDA

AS %LkBDACustomer

[Sales Ledger]

[Purchase Ledger Code]

[Customer Depot]

[Own Store]

NAAFI

[Nominal Cost Centere]

[Customer Group]

[Retail Group]

[Customer Scanning Version]

FROM

$(cFileName) (qvd)

;

ENDIF

Help with MULTI BOX

nathanfurby — Fri, 23 Jul 2010 10:54:26 GMT

Well if you know that the first 4 characters of the number are always going to be the 'group' then just replace Johannes' expression with a Left:

Left(F1,4) AS GroupNum,

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 11:40:00 GMT

Hi, Thanks for your help, i can get that working if i change the example that Johannes attached, but i can't seem to get it working in my script.

where would i put it? this is my script;

LOAD

[Customer Group],

[Retail Group],

[Customer Scanning Version]

FROM $(cfilename) (qvd);

ENDIF

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 12:51:34 GMT

Any more help anyone?

Help with MULTI BOX

nathanfurby — Fri, 23 Jul 2010 12:55:34 GMT

Like this:

LOAD

[Customer Group],
[Retail Group],
[Customer Scanning Version],
LEFT([Customer Scanning Version],4) AS VersionGroup

FROM $(cfilename) (qvd);

Help with MULTI BOX

hopkinsc — Fri, 23 Jul 2010 13:14:50 GMT

Thanks, for some reason it didn't work in my script, It blanked out some other fields.

But i tried it in an expression in my multi box and it worked great.

Thanks for your help 🙂