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: 
QlikAngel
Partner - Creator
Partner - Creator

Max Price Vs. Least Price in Year

Please find attach sample data with in sheet 2 required output

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try:

Max Purchase Date Price: FirstSortedValue({<Year={'$(=Max(Year))'}>} [Unit Price], -Date)

Min Price: Min({<Year={'$(=Max(Year))'}>} [Unit Price])

View solution in original post

10 Replies
QlikAngel
Partner - Creator
Partner - Creator
Author

Its Current Most Max Purchase  - Price & Minimum Price purchased in same org for same item in selected Year

jonathandienst
Partner - Champion III
Partner - Champion III

And your question is?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
QlikAngel
Partner - Creator
Partner - Creator
Author

Minimum Purchase Price againt that Item & Org .. check SHeet 2 in excel.. with Expected Output

tresesco
MVP
MVP

Straight table:

Dim1: Org

Dim2: Item

Exp1: Max({<Year={'$(=Max(Year))'}>} [Unit Price])

Exp2: Min({<Year={'$(=Max(Year))'}>} [Unit Price])

prma7799
Master III
Master III

Hi Mayuring,

As tresesco‌ said

PFA

Thanks

QlikAngel
Partner - Creator
Partner - Creator
Author

The logic should be Current means Max Purchase Date -  againt that Price ..& Min Price Means in selected Year for Same Item & Org Minimum Purchase Price.

if A item Purchase in Jan at rs. 350, in Feb at Rs. 300 & in Mar at rs. 200 than output will be below

A - Current Purchase Price will be 200, & Minimum Price will be 200.

Digvijay_Singh

F23 Org is missing in your expected output? Not sure why!

Digvijay_Singh

Your date format is DD-MM-YYYY or MM-DD-YYYY?

QlikAngel
Partner - Creator
Partner - Creator
Author

F23 is missing bcz output year is 2016 & date format is DD-MM-YYYY