Discussion Board for collaboration regarding Qlik DataMarket.
I have the following issue.
I anaylse values with I get direct from an database with many many tables in it.
So I am loding the required values into qlikview.
Now I am using Table-Diagram to make combine / visualise the values.
For the item characteristic values I have to use an WildMatch.
=if(WildMatch(FEATURE1,'WST*'),ItemDescription) --> Material
=if(WildMatch(FEATURE1,'BAB*'),ItemDescription) --> Thickness
=if(WildMatch(FEATURE1,'BAL*'),ItemDescription) --> Length
Item# / Stock / Last change / Material / thickness / length
a 2 01/03/2016 1,4571 - -
a 2 01/03/2016 - 1 -
a 2 01/03/2016 - - 20
I need the values in one row.
a 2 01/03/2016 1,4571 1 20
The item properties are in separate tables.
The KEY is the Item#--> with the item number I get the Item properity codes (FEATURE1) like WST (Material), BAB (Thickness), ...
and over the properity code I get the required value for the material.
How I can combine the values in one row?
Thank you in advance
May be like this:
Sum(Alt(Material, 0)) as Material,
Sum(Alt(Thickness, 0)) as Thickness,
Sum(Alt(Length, 0)) as Length
Group By [Item#], Stock, [Last Change];
UPDATE: added the Group By Statement I forgot earlier
When you load the different tables, use a join on the correct key (I guess Item#). That will put your values next to each other instead of under each other (what you'd typically do with a concatenate statement)
Hello together thank you very much.
I used the Sum(Alt(...
Sum(Alt(if(WildMatch(FEATURE1,'BAB*'),ItemDescription))) --> Thickness
It is working for the thickness and length.
Unfortunately it is not working for the material, I think the reason is.
That the material data is mixed with numbers and characters.
e.g. 2.4856 / Inconel 625
How I can Display text, with that Expression.
so I used Concat for the Expression.
and it worked I do not know why but it worked.
Concat(if(WildMatch(SachmerkmalMAP,'WST*'),ItemDescription)) --> Material