# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor II

## Variable in set Analysis

I have a variable "Vandaag" which is defined as

concat(Text(year(Now() )) & if(len(text( num(month( now()))))= 1,'0'&text( num(month( now()))) ,text( num(month( now())))) &if(len(text( num(day( now()))))= 1,'0'&text( num(day( now()))) ,text( num(day( now())))) )

and it results in a date like number 20190212

I want to use it in this statement, which works if I just write the number:

=Sum({\$<Begindatum={"<20190212"}>}Werktijdfactor_Week) (Note that "Begindatum"  is a similar number)

But when I use the Variable

=Sum({\$<Begindatum={"<\$(Vandaag)"}>}Werktijdfactor_Week) or

=Sum({\$<Begindatum={"<\$(=Vandaag)"}>}Werktijdfactor_Week) or

=Sum({\$<Begindatum={"<\$(#Vandaag)"}>}Werktijdfactor_Week)

it doesn't work
Does anyone have a suggestion?

1 Solution

Accepted Solutions
Valued Contributor

## Re: Variable in set Analysis

Hi Hagemann,

Please try to use below expression, it works in my desktop sample:

`=Sum({\$<Begindatum={"<\$(=\$(Vandaag))"}>}Werktijdfactor_Week)`

Thanks.

Aiolos Zhao

6 Replies
Honored Contributor II

## Re: Variable in set Analysis

try this

`=Sum({\$<Begindatum={"<\$(=\$(Vandaag))"}>}Werktijdfactor_Week) `

if this doesn't work please put a equal to(=) in your variable defination and then simply use

`=Sum({\$<Begindatum={"<\$(Vandaag)"}>}Werktijdfactor_Week) `
Learning never stops.
Valued Contributor

## Re: Variable in set Analysis

Hi Hagemann,

Please try to use below expression, it works in my desktop sample:

`=Sum({\$<Begindatum={"<\$(=\$(Vandaag))"}>}Werktijdfactor_Week)`

Thanks.

Aiolos Zhao

New Contributor II

## Re: Variable in set Analysis

The first option gives a result, but if i Change LT in GT then the result does not change while it should.
Thx though!
New Contributor II

## Re: Variable in set Analysis

Thank you: it works perfect. I cannot understand why. Is there a document that could teach me this?

Kind regards,
Hans Hagemann
Honored Contributor II

Highlighted

## Re: Variable in set Analysis

I think your problem is caused from the number-string which you have created in the variable and which could be easier created with something like:

Vandaag:
= num#(date(today(), 'YYYYMMDD'), '######')

and then you might use:

Sum({\$<Begindatum={"<\$(Vandaag)"}>}Werktijdfactor_Week)

or if there is no further use for the variable you could use the logic directly within the set analysis like:

Sum({\$<Begindatum={"<\$(=num#(date(today(), 'YYYYMMDD'), '######'))"}>}Werktijdfactor_Week)

- Marcus