Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

How to combine several rows to one row

Hello,

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.

Item#    /   Stock   /  Last change   /  Material   / thickness  / length

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

4 Replies
MVP
MVP

Re: How to combine several rows to one row

May be like this:

LOAD [Item#],

          Stock,

          [Last Change],

          Sum(Alt(Material, 0)) as Material,

          Sum(Alt(Thickness, 0)) as Thickness,

          Sum(Alt(Length, 0)) as Length

FROM Source

Group By [Item#], Stock, [Last Change];


UPDATE: added the Group By Statement I forgot earlier

puttemans
Valued Contributor

Re: How to combine several rows to one row

Hi,

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)

Regards,

Johan

Not applicable

Re: How to combine several rows to one row

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.

Thank you in advance

Not applicable

Re: How to combine several rows to one row

Hello,

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

Thank you

Community Browser