topic Re: set analysis with variable in QlikView

set analysis with variable

adiarnon — Sun, 19 Jan 2014 11:53:55 GMT

i have a problem with my expresion:

Sum({$<Year=,Month=, Date={">=$(VStartDate1)<$(VEndDate1)"}>}Complain)

VStartDate1--> =(AddYears(min(Date),-1))

VEndDate1--> =(AddYears(max(Date),-1))

why its not working (giving the wrong number)

maybe i need to take off the '='

tnx

Re: set analysis with variable

swuehl — Sun, 19 Jan 2014 12:06:28 GMT

What do you mean with 'wrong number', could you post a small sample application and your requested results?

In general, I would start with checking if the dollar sign expanded variables are expanded correct and in the required format (format of field Date). Paste your expression in a straight table (no dimension required), then hover over the expression label, you should see the expression with variables expanded.

Re: set analysis with variable

adiarnon — Sun, 19 Jan 2014 12:19:02 GMT

hi,

if in the variable i put VStartDate1-->(AddYears(min(Date),-1)) without = before

and im adding a text box with =$(VStartDate1) i get 01/01/2014

and if in the variable i put VStartDate1-->=(AddYears(min(Date),-1)) with = before

and im adding a text box with =$(VStartDate1) i get 0.088.....

witch i should choose and how can i put in the setanalysis?

Re: set analysis with variable

swuehl — Sun, 19 Jan 2014 12:22:38 GMT

Try an equal sign before your variable definition, then enclose the variable expansion in single quotes:

Sum({$<Year=,Month=, Date={">='$(VStartDate1)'<'$(VEndDate1)'"}>}Complain)

or instead, use the num() function in your variable definitions (also with equal sign before the expression):

=num(AddYears(min(Date),-1))

Re: set analysis with variable

adiarnon — Sun, 19 Jan 2014 12:40:19 GMT

its not working....

Re: set analysis with variable

antoniotiman — Sun, 19 Jan 2014 22:03:00 GMT

Hi,

you add date() in the variables:

VStartDate1--> =date(AddYears(min(Date),-1))

Regards

Re: Re: set analysis with variable

adiarnon — Mon, 20 Jan 2014 08:56:51 GMT

this is th file,

sheet 7 with text box of the variables and the set analysis problem.

tnx

Re: set analysis with variable

antoniotiman — Mon, 20 Jan 2014 10:02:50 GMT

I connot open the document. Denied access.

Re: set analysis with variable

antoniotiman — Mon, 20 Jan 2014 10:24:06 GMT

You try to replace $ with 1

Re: set analysis with variable

adiarnon — Mon, 20 Jan 2014 10:25:50 GMT

can i do somthing to change it?

Re: set analysis with variable

antoniotiman — Mon, 20 Jan 2014 10:31:41 GMT

sum({1<.....,Date={.....

Re: set analysis with variable

adiarnon — Mon, 20 Jan 2014 10:33:35 GMT

not working....

i think i try every possible syntax

Re: set analysis with variable

sushil353 — Mon, 20 Jan 2014 10:45:31 GMT

Hi,

Make sure that your Date field and the calculated variable format is same...

HTH,

Sushil

Re: set analysis with variable

antoniotiman — Mon, 20 Jan 2014 10:52:41 GMT

sum({1<Pdv=P(Pdv),NData={"<=$(maxdata)>=$(mindata)"}>} sales)

Re: set analysis with variable

adiarnon — Mon, 20 Jan 2014 11:42:11 GMT

i added a field of num(Date) and i entered it in the set analysis and it worked.

tnx evryone!!