I have Excel-data, that looks like this:
The result (just a usual table in QLIK) shall look like this:
So I just want the latest data to be shown outgoing from the date of invoice (Rechnungsdatum). I thought about creating a dimension for "Name", but as I am missing a command as "for" I don't know how to do it. Would be great if you can help.
Solved! Go to Solution.
there are several ways to do this, the easiest is to precalculate with firstsortedvalue.
Remember: everything you do in the front-end is calculated at runtime. It is therefore advised to do the calculation in the Qlik script.
max(Rechunungsdatum) as your_last_date
resident t1 group by projekt;
where your_flag = 1;
if( Rechunungsdatum = your_last_date, 1, 0 ) as your_flag
drop table t1;
Thanks for the help, when I use FirstSortedValue this is the result.
I would really like to use it as a dimension, as I will leave my employer very soon and I think the further users will understand a dimension better than changes in the script. The loading time shouldn't be a problem.