topic Re: rolling months data in QlikView

data

Anonymous — Mon, 25 Jan 2016 15:57:27 GMT

Hello

Attached is the sample attachement.

please let me know suggestions.

markodonovan — Mon, 25 Jan 2016 16:02:33 GMT

Hi John,

You should find this post by HIC useful

Thanks

Mark

sunny_talwar — Mon, 25 Jan 2016 16:06:49 GMT

Try the attached out:

Expression:

=Sum({<[AutoNumber(YrPd)] = {"$(='>=' & Min([AutoNumber(YrPd)]) & '<=' & (Min([AutoNumber(YrPd)])+ 12))"}, YrPd, Yr, Pd>}Value)

Anonymous — Mon, 25 Jan 2016 16:19:23 GMT

Thanks SUnny

this works fine but i need one more bar which shows the previous year 13 months roll back data

i.e one bar shows 2015p16 -13 and the other bar shows 2014p16-13

could you please let me know that expression.

sunny_talwar — Mon, 25 Jan 2016 16:28:38 GMT

Not sure I understand. what is 2015p16-13?

Anonymous — Mon, 25 Jan 2016 16:43:08 GMT

that is roll back of 13 months for previous year

sunny_talwar — Mon, 25 Jan 2016 16:46:27 GMT

Something like this?

Blue is Max - 13,

Red is LY Max - 13

Anonymous — Mon, 25 Jan 2016 16:47:40 GMT

yes but can you write the expression here?

because i cannot open your attachment

sunny_talwar — Mon, 25 Jan 2016 16:48:46 GMT

Expression:

=Above(Sum({<[AutoNumber(YrPd)] = {"$(='>=' & Min([AutoNumber(YrPd)]) & '<=' & (Min([AutoNumber(YrPd)])+ 25))"}, YrPd, Yr, Pd>}Value), 13)