Counting lines in table

[dries_clairhout]

Dear users,

I have a problem with one of my clients.

We need to know the number of orders.

To do this I go to table: KLORDHFD

In this table there is a collumn KOH-NR wich has all the orderheaders.

Now to know the number of headers within a selection I need to count all the lines in this collumn.

I did:

KOH-NR as CorrectOrder;

then in the expression in Qlik Sense for visualisation I did count(distinct CorrectOrder);

But this gives a number 1000x what it should be,

any help?

Thanks in advance

Dries

[swuehl]

Can you give some more information about your model, the selection you are doing (on which fields)?

Also some sample lines of data might help to understand, best in combination  with your expected result vs. the actual result.

[dries_clairhout]

So above is the graphic i'm talking about.

this is the code to import the collumn:

[swuehl]

But how is the field "KOH-NR" connected in your model with your other fields, like the one used as dimension (Dag)?

[dries_clairhout]

I don't really understand the question.

I'm sorry.

Fairly new to Qlik