QlikView - Use a variable into set analysis expression

variables set analysis qlikview
JAEP picture JAEP · Feb 21, 2014 · Viewed 31.3k times · Source

I've the variable varCurrentYear

varCurrentYear = Year(Today())

And I wrote this set analysis expression

Expression

The result it’s not correct. By the way If the variable is declared in this way

varCurrentYear = 2014

The result is correct.

Why? Thank's

Answer

Stefan Walther picture Stefan Walther · Feb 23, 2014

I'd use 

Sum({$<Year={'$(varCurrentYear)'}>}Orders)

resp without quotes if varCurrentYear is numeric

Sum({$<Year={$(varCurrentYear)}>}Orders)

See http://tools.qlikblog.at/SetAnalysisWizard/?sa=MCKA

Regards Stefan

Related questions

How can I simulate an array variable in MySQL?

It appears that MySQL doesn't have array variables. What should I use instead? There seem to be two alternatives suggested: A set-type scalar and temporary tables. The question I linked to suggests the former. But is it good practice to …

Read More
How to store Query Result in variable using mysql

SET @v1 := SELECT COUNT(*) FROM user_rating; SELECT @v1 When I execute this query with set variable this error is shown. Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server …

Read More
Declare variable set = select

This probably sounds like a really stupid question, but how do I declare a variable for used in a PostgreSQL 9.3 query? CREATE or replace FUNCTION public.test() returns int4 AS $BODY$ DECLARE cod_process bigint :=30001; cod_instance bigint ; utc_log …

Read More