AvialablePeriodvalues

[antonybi]

Hello everyone,

Could some one please suggest where I did wrong.

I wanted to see the values 10,30(in highlighted in yellow) aswell for Jan-20 period selection. here(Below snapshot) I could seen only TestPeriod which are latestperiod for the respective markets but not values in testData. 

Could you please some one help me out with this scenario.

Attached, testapp for your reference.

[basav]

Hi Antony,

It looks like, Value 10 and 30 are not associated with Jan-20. Please verify the data source. I also don't see it in the table you have loaded. 

-Basav

[antonybi]

If you noticed,for the section of Jan-20 I'm also getting Oct-19, Dec-19 for AL and MT respectvely.

I wanted to se the values as well for the same selection.(it is showing in blank In testData I've highlighted in yellow)

and find my expressions in the below.

Dim: Market

TestPeriod(Exp1): Max({<MonthYr={'<=$(vKPI_Period_default)'}>}MonthYr)

testData: Only({<MonthYr={'$(vKPI_Period)'}>}Value)

Variable definitions: 

vKPI_Period_default : =Only(MonthYr)

vKPI_Period: =Date(Max({<MonthYr={'<=$(vKPI_Period_default)'}>}MonthYr),'MMM-YY')

[basav]

Hi Antony,

Well, I just made some changes as below:

vKPI_Period: =Date(Max({<MonthYr={'<=$(vKPI_Period_default)'}>}MonthYr),'MMM-YY')

TO

vKPI_Period: =Date(min({<MonthYr={'<=$(vKPI_Period_default)'}>}MonthYr),'MMM-YY')

Its now, showing all the values. Please check the attached png file. 

-Basav

[antonybi]

I think it is fetching min period values

what if ? the table is something like below

temp:
Load*Inline
[
MYr, Market, Value
Oct-19, AL, 10
Oct-19, MT, 15
Oct-19, IE, 50
Oct-19, GR, 70
Oct-19, IT, 90
Dec-19, MT, 30
Dec-19, IE, 50
Dec-19, GR, 70
Dec-19, IT, 90
Jan-20, IE, 50
Jan-20, GR, 70
Jan-20, IT, 90
];

Here I'm expecting 30 for MT and 10 for AL.