LET vMarkt = peek('Tmp_Markt_Field', $(a), 'Tmp_Markt');
Markt as TestMarkt
, Artikel as TestArtikel
, RowNo()-1 as Rank
Resident Abschriften where Markt = $(vMarkt) order by Abschrift_1;
drop field ID;
drop table Tmp_Markt;
I want to have a rank based on the KPI Abschrift1 per market. But qlik sense gives me back a rank on total. But I don't know why? First I rank the artikel for makrte 1 and make a cocanenation on Final and then he takes the market 2 and makes a cocncatenoin on Final. But the result is in total for Rank 1,2,3,4,5,6,7,8,9,10 but I need thik like 1,2,3... for market1 and 1,2,3... for market two.