Adding only the latest period

[#1]

Hi everyone!

1. One object in my QV document should involve only the latest period. Period variable is Month (1,2,3, etc.).
   For example I have two fields: month and income. And in one object I want restrict Income average by latest mmonth. In what way it should be scripted?

1. Does QlickView allow to estimate statistic differences among periods? I need to compare indexes over the latest period and previous one. In what way it should be done if it is possible?

Thanks in advance!

[ramoncova06]

yes you can get different periods in QV

should be something like

sum({<Month={"$(=max(Month)"}>}value) //latest month

sum({<Month={"$(=max(Month,2)"}>}value) //previous month

A Primer on Set Analysis

QlikView App: Dates, Date Ranges and Set Analysis

Set Analysis: syntaxes, examples

[#3]

Ramon, thank you so much!

It works!

Do you happen to know whether it is possible to compare two periods in QlickView? In the long run I need calculated index of the latest month (you've already helped me with that, many thanks!) and an arrow identifying is it higher, lower or at the same level as in previous month.

It should be something like that:

Is it possible to script such a condition for these arrows?

Thanks in advance!

[oknotsen]

I would do this by using a Traffic Light gauge (see Display Options on the Expression tab).

Add an expression like this:

if( sum({<Month={"$(=max(Month)"}>}value) > sum({<Month={"$(=max(Month,2)"}>}value) , 1, 0)

The default Traffic Light Gauge should now show either a red or green light.

[ramoncova06]

yes you can you need to set results as an image representation here is a post on how to do it Display images in straight table