topic Re: Re: date-variables in set analysis in QlikView

date-variables in set analysis

Tue, 14 Jan 2014 10:22:00 GMT

Hi there,

I Need to set the current date in the string, but it doesn´t work.

I have a field, named MeassureDate. There are values like '12.01.2014', '13.01.2014', '14.01.2014' and so on.

Temperature contains weathervalues: 5,2,3,4,7,8 and so on. (Values in °C). Hundreds of values a day.
In Script I set the variable vActDate to Today()

now I made a set Analysis-formula:

Max( {1<MeassureDate = {$(#vActDate)}> Temperature)

A TextBox Returns me 14.01.2014 for vActDate, bit the Set Analysis won´´t work. I get only a '-'.

Does anybody know, how to bind the variables functionaly in the Set Analysis-String?

Thanks a lot for your Help!

Marcel

Re: date-variables in set analysis

jvishnuram — Tue, 14 Jan 2014 10:25:39 GMT

Hi Marcel,

first thing i observer from your expression is ')' closing parentheses is missing, if it is correct so then use Date() function while assigning the variable., like Date(Today()).

Re: date-variables in set analysis

jonathandienst — Tue, 14 Jan 2014 10:28:06 GMT

Marcel

Try this:

Max( {1<MeassureDate = {"$(=Date(vActDate, 'DD.MM.YYYY'))"}>} Temperature)

HTH

Jonathan

edit: fixed missing closing bracket

Re: date-variables in set analysis

mjm — Tue, 14 Jan 2014 10:29:18 GMT

Hello Marcel,

From looking at the script you gave, the first ( after Max is actually red. This identifies an error with this bracket. So you should need another closing ) at the end it seems.

Re: date-variables in set analysis

Tue, 14 Jan 2014 10:37:41 GMT

Sorry, but doesn´t work.

Max({1<MeassureDate = {"$(=Date(vActDate, 'DD.MM.YYYY'))"}>} Temperature)

Re: date-variables in set analysis

Tue, 14 Jan 2014 10:39:01 GMT

Yes, I copied it from QV. And only here I lost the bracket.
It does not work with the bracket also. 😞

Re: Re: date-variables in set analysis

Tue, 14 Jan 2014 10:57:59 GMT

Hi,

I tried this, but no success:

In Script:
Set vActDate = Date(Today())

In Object:
Max( {1<MeassureDate = {$(#vActDate)}>} Temperature)

I put it in a Textfielt, with '=' at the beginning. I got a Entry in the TextBox:
Error in set modifier ad hoc element list: ',' or ')' expected.

But where?

I put the file to this Message.

Re: date-variables in set analysis

Tue, 14 Jan 2014 11:47:55 GMT

Hi Marcel,

Try the below expression:

max({$<MeassureDate ={"=$(vActDate)"}>} Temperature)

Also makesure that the date formats are same when comparing.

Hope it helps!.

Thanks

Re: date-variables in set analysis

Tue, 14 Jan 2014 12:24:00 GMT

Hi PriyankaSR,

I am getting values. But it is the values for the date, which I have selected in the list box "MeassureDate". But I wanted that getting the values for the date value in the variable vActDate be abgezeigt. Now I have set a 1 instead of the $, but it does not work. There is always the valid value from the list box ("MeassureDate" used to indicate Max (Temperature).

Do you have an idea for this?

Thanks.

Re: date-variables in set analysis

kiranmanoharrode — Tue, 14 Jan 2014 12:56:22 GMT

Dear Marcel,

Just go to variable overview (Ctrl+Alt+v) and correct variable vActDate

=Date(Today())

Regards,

Kiran Rode

+91 8976977897

Re: Re: date-variables in set analysis

Tue, 14 Jan 2014 13:02:09 GMT

I had already.

Re: date-variables in set analysis

brijesh1991 — Tue, 14 Jan 2014 13:03:54 GMT

vActDate=Date(Today(),'DD.MM.YYYY')

we have set DD.MM.YYYY for today date, so the same should be for your MeassureDate or vice versa.

Max({$<MeassureDate = {'$(vActDate)}'> Temperature)

Re: Re: date-variables in set analysis

Tue, 14 Jan 2014 13:16:57 GMT

Hi,

it doesn´t work.

Example attached.

Re: date-variables in set analysis

kiranmanoharrode — Tue, 14 Jan 2014 13:21:24 GMT

Dear Marcel,

Please add '=' sign before your expression. It will definately work.......:)

Regards,

Kiran Rode

+91 8976977897

Re: date-variables in set analysis

kiranmanoharrode — Tue, 14 Jan 2014 13:23:07 GMT

Dear Marcel,

Use below Expression.

=Max({<MeassureDate={"$(vActDate)"}>}Temperature)

Regards,

Kiran Rode

+91 8976977897

Re: Re: date-variables in set analysis

Tue, 14 Jan 2014 13:25:01 GMT

Sorry, I get the value 0. It must be 7.

Re: date-variables in set analysis

atafsson — Tue, 14 Jan 2014 16:09:42 GMT

Textbox:

=max({1<MeassureDate ={'$(vActDate)'}>} Temperature)

Regards

Axel

Re: date-variables in set analysis

Wed, 15 Jan 2014 05:06:58 GMT

Hi Marcel,

Try the below expression.

The diference here compared to my earlier expression is with the quotes applied on the variable.

Hope it works for you !

=sum({$<MeassureDate ={'$(vActDate)'}>} Temperature)

Thanks

Re: date-variables in set analysis

kiranmanoharrode — Wed, 15 Jan 2014 05:14:21 GMT

Dear Marcel,

PFA for a solution

Regards

Kiran Rode

+91 8976977897

Re: date-variables in set analysis

nizamsha — Wed, 15 Jan 2014 05:40:59 GMT

=Max({$<Date={'$(vActDate)'}>}Temperature)