Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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$