Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

count amount of nr by match between two columns in two tabels

Hi comm,

I have the following problem.

I want to count the article_nr of table1 by a type_string from table2 that is a part of an element_string from table.

I think I need count, wildmatch and aggr or set analysis.

I tried a lot but I couldn't find the right formular.

so for example i have

in table 1

nr    element_string  .... 

1     11(2)230          .....   

2     11(2)230           ......

3     12(2)330          .....

4     11(2)230           ....

5     09(4)234              .....

in table i want to show

type_string     amount

230               3

330               1

234               1

hopefully I have explained it in a way u guys understand it.

Thx for an answer.

2 Replies
mov
Esteemed Contributor III

Re: count amount of nr by match between two columns in two tabels

The most natural thing to do is to create type_string field in the table 1, for example:

right(element_string,3) as type_string

or

subfield(element_string, ')', 2) a type_string

Not applicable

Re: count amount of nr by match between two columns in two tabels

yeah allready thoughed about this. im editing the load script atm