topic Re: Show only first date with number to this date in QlikView

Show only first date with number to this date

Sat, 17 Oct 2015 14:04:38 GMT

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.

Re: Show only first date with number to this date

Anonymous — Sat, 17 Oct 2015 18:15:19 GMT

Maybe try using Chart of type Straight Table and :

Dimension: Number
Expression: Min(Date)

Re: Show only first date with number to this date

evan_kurowski — Sat, 17 Oct 2015 18:21:05 GMT

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

Re: Show only first date with number to this date

Sat, 17 Oct 2015 18:39:40 GMT

Thank you for the fast answer. it works

Re: Show only first date with number to this date

Sat, 17 Oct 2015 19:21:24 GMT

Load date,number

from Path

where not exists(date,number);

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