Discussion Board for collaboration related to QlikView App Development.
I have a requirement to be done in Qlikview, which should yield the same result as same as Teradata Query
Select Country, SalesPerson, Customer, Division, Qty, Amount, Date, EXTRACTION_DATE From XXX.Sales
QUALIFY ROW_NUMBER() OVER (PARTITION BY CountryORDER BY EXTRACTION_DATE DESC) = 1;
How to write this query in Qlikview?
But i am not planning to write this in extraction script, after extracted from Database and Stored into QVD, i will load the QVD and filter out.
Thanks in Advance,
autonumber(ROWNO(),Country) as NumCount,
Country, SalesPerson, Customer, Division, Qty, Amount, Date, EXTRACTION_DATE
Thanks for your reply.
Let's say I have records like this , as per the query i mentioned, i should get only one row, where ExtractionDate is in descending
What about this:
Country, SalesPerson, Customer, Division, Qty, Amount, Date, min(EXTRACTION_DATE) as EXTRACTION_DATE
Country, SalesPerson, Customer, Division, Qty, Amount;
Min(Extraction Date) will return only the first value, but according to my scenario, i have two different records for same Country, Customer, SalesPerson and Division, in that i need to take out the max - Extraction date