Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Help with MULTI BOX

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?

1 Solution

Accepted Solutions
hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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 🙂

View solution in original post

11 Replies
Not applicable

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

Anonymous
Not applicable

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

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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?

nathanfurby
Specialist
Specialist

What do your actual version numbers look like?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Sorry, they loom like

1033

10331

10333

10334

103318

1051

1052

10525

10529

105214

105218

Sorry to mess you all about 😞

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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



nathanfurby
Specialist
Specialist

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,

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Any more help anyone?