Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
surendraj
Specialist
Specialist

First Value in the table

Hi All,

in the below table, i need to capture the first value of the price for every model and month_year in a new field. (need in script level)

For Example:

for a model , if we have price for july2017 then we consider that price . if  july2017 has no price then we capture the price for aug2017  and so on ..

Table.JPG

25 Replies
sunny_talwar

Can you share a sample or may be sample data in an Excel file.... or share the script you have been trying

stabben23
Partner - Master
Partner - Master

Its half because of the Group by Crawlwer, Manufacturer and Category.

I'll think Model will be enough

surendraj
Specialist
Specialist
Author

even we keep only model also.. i m getting half values

stabben23
Partner - Master
Partner - Master

Have you tried this?

MinPrice:

LOAD

Model,

date(min(MonthLastDay),'DD-MM-YYY') as Min_MonthYear,

firstsortedvalue(Price, MonthLastDay) as Min_Price

Resident Your table

Group by Model;

surendraj
Specialist
Specialist
Author

can u tell me ur mail id .,. i shall send it ..

surendraj
Specialist
Specialist
Author

no data coming into min_price .