Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
Creator
Creator

AvialablePeriodvalues

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. 

antonybi_0-1593488839909.png

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

Attached, testapp for your reference.

4 Replies
basav
Creator
Creator

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
Creator
Creator
Author

 

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
Creator
Creator

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
Creator
Creator
Author

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.