Forming a new single dimension using items from different multiple fields

[KZD]

Hello all,

I'm very new using qliksense and I have no previous knowledge of sql etc. I'm a bit history/geography person lets say 🙂 so I desperately need help on even beginner topics.

My question is as follows:

I have several fields with different hierarchies in my loaded data and I want to form a single new dimension to use it in my table.

Field1 name=Product line 1 (consisting of: personal credits, car credits, mortgage, spot credits). I want to take only personal, car, mortgage from this field.

Field 2 name= Product line 2 (tl credits, fx credits). I want to take both tl and fx.

I want to form a dimension lets name it: Product line_used and I want to combine field 1 selected items+field2 selected items.

Product line _used must be a dimension like below:

Personal credits

Car Credits

Mortgage

TL credits

FX credits.

Any help will be highly appreciated.

Thanks a lot

[Aditya_Chitale]

for taking selective data from a field, you can use "where" clause at the end of your load script 

table1:
load
..
..
..
from [lib://xyz.xlsx]
where [Product line 1]='Personal Credits','car credits','mortgage';

Regards,

Aditya

[KZD]

Thanx for your answer Aditya.

Actually your answer is to the part 1 of my question.

After limiting my data as you said how can I combine multiple fields "one under other" to form a single new dimension?

Regards

[Aditya_Chitale]

Do you want to make selections on newly created dimension or link the consolidated dimension table with any other table from data model ? 

Regards,

Aditya

[KZD]

I could actually bring the items (from different fields) one under the other. (Using load*inline)

My dimension is now as follows:

Personal credits

Car credits

Mortgage

TL credits

FX credits

But when I try to add a measure using Sum (usd_outstanding balance). Every line brings the total balance.

I mean it should be like this:

Personal credits.....10 $

Car credits...............20$

Mortgage..................50$

TL credits.................100$

FX credits.................40$

But it brings like this:

Personal credits.....220$

Car credits..............220$

Mortgage.................220$

Tl credits.................220$

Fx credits.................220$