topic Adding only the latest period in QlikView

Adding only the latest period

Mon, 15 Jun 2015 13:44:12 GMT

Hi everyone!

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?

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!

Re: Adding only the latest period

ramoncova06 — Mon, 15 Jun 2015 21:08:48 GMT

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

Re: Adding only the latest period

Tue, 16 Jun 2015 09:08:19 GMT

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!

Re: Adding only the latest period

oknotsen — Tue, 16 Jun 2015 09:15:10 GMT

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.

Re: Adding only the latest period

ramoncova06 — Tue, 16 Jun 2015 14:14:24 GMT

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