topic Re: Single Table Splitted in QlikView

Single Table Splitted

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

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!

Re: Single Table Splitted

sergio0592 — Wed, 30 Jan 2019 10:00:14 GMT

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];

Re: Single Table Splitted

Gabriel — Wed, 30 Jan 2019 10:05:44 GMT

Hi,

Are you able to attach a sample data ?

Re: Single Table Splitted

its_anandrjs — Wed, 30 Jan 2019 11:19:27 GMT

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

Re: Single Table Splitted

qlikviewaf — Wed, 30 Jan 2019 11:41:07 GMT

interesting.

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

Thank you

Re: Single Table Splitted

its_anandrjs — Wed, 30 Jan 2019 12:05:43 GMT

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