topic Re: AvialablePeriodvalues in QlikView

AvialablePeriodvalues

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: AvialablePeriodvalues

basav — Tue, 30 Jun 2020 04:15:08 GMT

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

Re: AvialablePeriodvalues

antonybi — Tue, 30 Jun 2020 04:39:19 GMT

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')

Re: AvialablePeriodvalues

basav — Tue, 30 Jun 2020 05:27:16 GMT

Hi Antony,

Well, I just made some changes as below:

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

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

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

-Basav

Re: AvialablePeriodvalues

antonybi — Tue, 30 Jun 2020 07:12:07 GMT

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.