Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Display previous months data

Hi all

Please find attached .qvw and its supporting data.

I am looking to display all the 'Locations' value when Year/Month is selected.

Display all locations and its value.

Example:

When 2012 and June is selected table shows only' HongKong' with 'Value' 36 but I would like it to display all the 'Locations'. There is a lookup file 'Target' that has a field 'Months_Behind' therefore when Year=2012 and Month=June the table should display

HongKong           36           (as Months_Behind = 0 for HongKong, as June is selected it displays June's value)

London               38           (as Months_Behind = -1 for London, as June is selected its june -1 month wiz May's value) 

NewYork            25           (as Months_Behind = -2 for NewYork, as June is selected its june -2 month wiz April's value)

California            13           (as Months_Behind = -3 for California, as June is selected its june -3 month wiz March value)

Thank you.

4 Replies
Highlighted
MVP
MVP

Re: Display previous months data

attachment is missing

Highlighted
Not applicable

Re: Display previous months data

Sorry. Please see attached.

Highlighted
Not applicable

Re: Display previous months data

hi,

     if i am right then you don't want any changes according to year or month selection. You want to show all records.

and according to your excel sheet you are displaying max value for every location.

for that use this expression in chart:

=Max({$<MonthName=,Year=>} Value)

hope this helps.

Regards,

Ashutosh

Highlighted
Not applicable

Re: Display previous months data

True but it gives me Max value rather than giving the latest value.