topic Re: How to get price in QlikView

How to get price

kunkumnaveen — Fri, 10 Nov 2017 06:59:49 GMT

Hello All,

I need to pickup 31 st march average price of each year ,what I mean is

for Fiscal year 2018 =31-03-2017 date price

Fiscal year 2019= 31-03-2018 date price

Fiscal year 2020= 31-03-2019 date price....

So on

Date Model:

My first question is linking by fiscal year will work or not ,if it ok when how write a expression to bring

If selected Fiscal Year =2018 then

LOGIC:

Previous fiscal year's(FY2017) --->max (SPrice_Calday's )(31-03-2017)----> Avg(Sprice_Price )

Kindly give suggestions on above requirement please

Thanks

shraddha_g — Fri, 10 Nov 2017 07:06:53 GMT

Calculate YearEnd in your script as below

YearEnd(CALDAY,0,4) as YearEnd

In Expression, use

Avg( {<SPrice_Calday = {"$(=max(YearEnd))"}>}Sprice_Price )

Here, On Selection of Year (2016-2017) it will give you Avg price of the day 31st March 2017

kunkumnaveen — Fri, 10 Nov 2017 07:17:55 GMT

Hi,

Here, On Selection of Year (2016-2017) it will give you Avg price of the day 31st March 2017

I need 31st March 2017 price for the selection on fiscal year 2018(2017-2018)

shraddha_g — Fri, 10 Nov 2017 07:21:11 GMT

Try,

Calculate YearStart in your script as below

YearStart(CALDAY,0,4) as YearStart

In Expression, use

Avg( {<SPrice_Calday = {"$(=date(max(YearStart)-1,'DD-MM-YYYY'))"}>}Sprice_Price )