Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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

Labels (1)
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 .