topic Re: Grouping values for MultiBox in QlikView

Grouping values for MultiBox

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have a data list which shows a some values based on month.

Now my requirement is to create a MultiBox grouped by month names only

Example of my data:

2018_01_xxxx

2018_01_yyyy

2018_01_zzzz

2018_02_xxx

2018_02_yyy

Now the MultiBox should show me below, grouped by Months

2018_01

2018_02

Thanks

sunny_talwar — Tue, 20 Mar 2018 15:14:14 GMT

May be try an expression like this in the multibox

Left(FieldName, 7)

Chanty4u — Tue, 20 Mar 2018 15:19:38 GMT

orelse

keepchar(Filed,'0123456789_' ) as new

sunny_talwar — Tue, 20 Mar 2018 15:22:42 GMT

That will give

2018_01_ (an extra _ at the end)

olivierrobin — Tue, 20 Mar 2018 15:23:12 GMT

hello

do you absolutely need a multibox ?

one solution should be a listbox presented as a tree

but you need to change the 1st (or the 2nd) underscore by another character

Chanty4u — Tue, 20 Mar 2018 16:56:24 GMT

my bad i didnt notice last "_ "