topic Re: Variable in set Analysis in QlikView

Variable in set Analysis

hagemann — Tue, 12 Feb 2019 08:46:25 GMT

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?

Re: Variable in set Analysis

pradosh_thakur — Tue, 12 Feb 2019 09:23:46 GMT

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)

Re: Variable in set Analysis

uacg0009 — Tue, 12 Feb 2019 09:21:10 GMT

Hi Hagemann,

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

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

Thanks.

Aiolos Zhao

Re: Variable in set Analysis

hagemann — Tue, 12 Feb 2019 09:27:07 GMT

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

Re: Variable in set Analysis

hagemann — Tue, 12 Feb 2019 09:29:04 GMT

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

Kind regards,
Hans Hagemann

Re: Variable in set Analysis

pradosh_thakur — Tue, 12 Feb 2019 09:34:20 GMT

Have a look

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://ivan-shamaev.ru/wp-content/uploads/2014/08/Set_Analysis_pdf.pdf

Re: Variable in set Analysis

marcus_sommer — Tue, 12 Feb 2019 09:58:08 GMT

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