topic What I don't understand? in QlikView

What I don't understand?

Wed, 21 Sep 2011 12:34:43 GMT

See the file...

What I don't understand?

Wed, 21 Sep 2011 12:58:02 GMT

Hi,

It changes as your variable

Variable5 = =MaxString(Date#(DATE,'DD.MM.YYYY' ))

depends on the Date you are selecting.

You can see the definition of the Variable when you go to Menu-> Settings-> VariableOverview in the Qlikview Application.

Hope that helps

Regards

Sravan

What I don't understand?

Anonymous — Wed, 21 Sep 2011 13:30:41 GMT

Change your variabble to

=MaxString(Date(DATE,'DD.MM.YYYY' ))

That should work imo.

Good luck.

Dennis

Re: What I don't understand?

its_anandrjs — Wed, 21 Sep 2011 14:03:44 GMT

Hi,

Yes change your variable

From

=MaxString(Date#(DATE,'DD.MM.YYYY'))

=MaxString(Date(DATE,'DD.MM.YYYY'))

remove # symbol

Also Dennis is right

See sample file.

HTH

Rgds

Anand

Re: What I don't understand?

SunilChauhan — Wed, 21 Sep 2011 14:15:04 GMT

the input field without selection is value of date in number format

when you click on then it shoing in date format

you need to take

Variable5=Max(DATE)

please ssee the attached file

hope this give you solution

What I don't understand?

Wed, 21 Sep 2011 14:53:11 GMT

Sunil Chauhan wrote:
the input field without selection is value of date in number format
when you click on then it shoing in date format

Is it a bug?

What I don't understand?

Wed, 21 Sep 2011 15:10:16 GMT

and why when I use

Variable5=MaxString({<PERS=,ID=>}Date#(DATE,'DD.MM.YYYY' ))

i dont have this problem