QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Contributor

Max Price Vs. Least Price in Year

Please find attach sample data with in sheet 2 required output

1 Solution

Accepted Solutions
MVP

Re: Max Price Vs. Least Price in Year

Try:

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

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

10 Replies
Contributor

Re: Max Price Vs. Least Price in Year

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

MVP

Re: Max Price Vs. Least Price in Year

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Contributor

Re: Max Price Vs. Least Price in Year

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

MVP

Re: Max Price Vs. Least Price in Year

Straight table:

Dim1: Org

Dim2: Item

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

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

Honored Contributor III

Re: Max Price Vs. Least Price in Year

Hi Mayuring,

As tresesco‌ said

PFA

Thanks

Contributor

Re: Max Price Vs. Least Price in Year

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.

Honored Contributor III

Re: Max Price Vs. Least Price in Year

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

Honored Contributor III

Re: Max Price Vs. Least Price in Year

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

Contributor

Re: Max Price Vs. Least Price in Year

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