Single Table Splitted

[qlikviewaf]

Hi,

i have the table Dimensions here below that is a list of value (area, region etc)

I would like to create then multiple box with specific value coming from the same table

E.g. BOX N1 : just value AREA, BILL BILL N°

BOX N2°: just values brand country custom description

and so on...

how i can do this?

Thanks!

[sergio0592]

Hi, you have to make separate table dimension in your load statement.

Dimension1:
LOAD * INLINE [
_dimension1
AREA
BILL
BILL N°];

Dimension2:
LOAD * INLINE [
_dimension1
BRAND
COUNTRY
CUSTOM DESCRIPTION];

[Gabriel]

Hi,

Are you able to attach a sample data ?

[its_anandrjs]

Hi,

Are you able to add a field just to the Dimension field like

LOAD * Inline
[
_Dimension,Category
Area,1
Region,1
Product,2
Product Code,2
];

And in list box 1 select
If(Category =2,_Dimension)

And in second list box 2 select
If(Category =1,_Dimension)

Hope this helps.

Regards,
Anand

[qlikviewaf]

interesting.

Where "If(Category =2,_Dimension)" needs to be specified? i don't find a field into the listbox properties.

Thank you

[its_anandrjs]

Hi,

I am suggesting you have to add the field named "Category " in the table load of _Dimension. Which is not available on the properties.

Regards
Anand