topic Variable in QlikView

Variable

Anonymous — Wed, 02 Sep 2015 06:06:52 GMT

Hi,

I have two variables

vtwoyear=year(Today())-2

vcurrentyear=year(Today())

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(vCurrentYear and >=vtwoyear) "}

>} usage) to display data for last 2 years.

but not working.

Could you please help

Anonymous — Wed, 02 Sep 2015 06:10:26 GMT

use this Expression:

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(vCurrentYear)>=$(vtwoyear)) "}>} usage)

settu_periasamy — Wed, 02 Sep 2015 06:10:29 GMT

Try this

sum({<Environment={'$(=vEnvironment)'},Dept={'$(=Dept)'},Year={"<=$(=vCurrentYear)>=$(=vtwoyear)"}>}usage)

tresB — Wed, 02 Sep 2015 06:12:36 GMT

Try like:

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(vCurrentYear) and >=$(vtwoyear) "}

>} usage)

parthakk — Wed, 02 Sep 2015 06:17:29 GMT

Hi,

U want to display for current year along with previous two years or u want it for for selected year and year-2?

sasiparupudi1 — Wed, 02 Sep 2015 09:04:15 GMT

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(=Max(Year)) >=$(=Max(Year)-2) "}>} usage)

hth

Sasi