topic Display previous months data in QlikView

Display previous months data

Tue, 03 Dec 2013 13:50:53 GMT

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.

Re: Display previous months data

MK_QSL — Tue, 03 Dec 2013 13:51:27 GMT

attachment is missing

Re: Display previous months data

Tue, 03 Dec 2013 13:55:17 GMT

Sorry. Please see attached.

Re: Display previous months data

Tue, 03 Dec 2013 14:06:46 GMT

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

Re: Display previous months data

Tue, 03 Dec 2013 14:28:28 GMT

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