topic Re: max date script in QlikView

max date script

pgalvezt — Fri, 07 Nov 2014 13:12:52 GMT

Hello,

I can't get the max date in my script, I followed the steps to obtain the max date but I couldn't.

Any can help my with this?

I attached the qvw test.

Thanks!

Re: max date script

anbu1984 — Fri, 07 Nov 2014 13:14:41 GMT

Password is set on the attached qvw

Re: Re: max date script

pgalvezt — Fri, 07 Nov 2014 13:23:15 GMT

Sorry,

Re: max date script

Anonymous — Fri, 07 Nov 2014 13:30:17 GMT

Hi,

Please detail which date field (or fields) you want to know the max.

Marc.

Re: max date script

anbu1984 — Fri, 07 Nov 2014 13:31:39 GMT

Can you provide more details like on which date field, what is your expected output?

Re: Re: max date script

pgalvezt — Fri, 07 Nov 2014 13:33:14 GMT

Hi marc,

The date which appears on the pivot table. The idea is Qlikview shows me only 11/06/2014.

Re: Re: Re: max date script

Anonymous — Fri, 07 Nov 2014 13:40:32 GMT

Please reload and check the attached file.

Marc.

Re: Re: Re: Re: max date script

pgalvezt — Fri, 07 Nov 2014 13:45:20 GMT

I reloaded it again.

Re: Re: Re: max date script

Anonymous — Fri, 07 Nov 2014 13:49:10 GMT

I meant I add one tab in script that creates a table with the max date field. You will see it by reloading your data. Then in layout I added a conditional dimension using this max date field.

Marc.

Re: Re: Re: max date script

anbu1984 — Fri, 07 Nov 2014 13:52:26 GMT

Check this app

Re: Re: Re: max date script

Anonymous — Fri, 07 Nov 2014 13:57:14 GMT

Pablo,

Anbu's solution is fine if you do not need the max data field in your script.

Marc.

Re: max date script

pgalvezt — Fri, 07 Nov 2014 15:14:15 GMT

Hi, Marc,

There was an exit script in my Script. I moved your script line into my tab and I removed the exit Script Sentence. But Noting Happened Pivot table shows nothing.

Re: max date script

pgalvezt — Fri, 07 Nov 2014 15:15:48 GMT

Anbu,

Thanks for your answer, How Could I do for incorporate Codigo? When I put Codigo The table shows nothing. Can you help me with this?

Thanks!

Re: Re: max date script

anbu1984 — Mon, 10 Nov 2014 07:53:51 GMT

Check this app

Re: Re: max date script

pgalvezt — Mon, 10 Nov 2014 12:38:06 GMT

Hi, Anbu,

Thank you for your reply,

On the calculated dimension? I need to show as dimension.

Thanks!

Re: max date script

anbu1984 — Mon, 10 Nov 2014 12:43:10 GMT

Can you provide the expression you tried

Re: max date script

pgalvezt — Mon, 10 Nov 2014 12:58:35 GMT

Yes I did,

I copied the same formula but appears error in dimension calculated.

Re: Re: max date script

anbu1984 — Mon, 10 Nov 2014 13:17:17 GMT

If you want to add as dimension, then you add as Codigo. No need to use calculated dimension. Check this

Re: max date script

pgalvezt — Mon, 10 Nov 2014 13:22:22 GMT

Thank you anbu!