Show only first date with number to this date

[#1]

Hello,

I`m new to qlik view. I have loaded a table to qlik view.

The table box in qlik view and the skrypt you can see here:

Now, I dont want to see all the dates with the same numbers. I only want to load the numbers with the first date, so that I will get this table, only with 2 rows:

How I have to edit the scrypt? How should the scrypt looks like?With firstsortedvalue? I have tried some things but it didnt help me.

[Anonymous]

Maybe try using Chart of type Straight Table and :

• Dimension:  Number
• Expression:  Min(Date)
  
  

[evan_kurowski]

LOAD Number, Min(Date) AS Date
FROM [Mappe1.xlsx] (ooxml, embedded labels, table is Tabelle1)
GROUP BY Number;

[#4]

Thank you for the fast answer. it works

[#5]

Load date,number

from Path

where not exists(date,number);

press cntl+r select table box it show only distinct values