topic Re: dynamic date in QlikView

dynamic date

maternmi — Thu, 29 Jan 2015 13:51:48 GMT

Hello,

I would like to generate a dynamic date in the script (for short period is it a fix date) for all orders (ID), which I can compare with a delivery date. At the end I would like to show all orders in the chart with a delivery date before the dynamic date and hide all order in the chart after the dynamic date --> if(dynamic date >= delivery date, delivery date, 'not relevant')

As dynamic date I would like to have the first MonthYear (e.g. 04.2015 or 07.2015 or 10.2015 or 01.2016....) of each quarter but always the smallest one. For example the next smallest dynamic MonthYear is 04.2015 and as soon as we reached 04.2015, then it switched to the next 07.2015 and so on...

How can I do it? Below you can see what I mean.

Order no.	Delivery Date	Delivery MonthYear	Dynamic MonthYear
0001114992\001000	29.01.2015	01 2015	04 2015
0001114511\001000	16.02.2015	02 2015	04 2015
0001115038\001000	10.04.2015	04 2015	04 2015
0001115485\001000	12.05.2015	05 2015	04 2015
0001115469\001000	03.07.2015	07 2015	04 2015

Michael

Re: dynamic date

crusader_ — Thu, 29 Jan 2015 13:59:51 GMT

Hi,

Use below expression in script

LOAD

...

date(QuarterStart(today()),'MM.YYYY') as [Dynamic Month Year]

FROM datasource;

Hope this helps.

Regards,

Andrei Kaliahin

Re: dynamic date

maternmi — Thu, 29 Jan 2015 14:16:18 GMT

Hi Andrei,

I can try it but I expect as result the current MonthYear = 01.2015, but I always need the next one and from today view it is 04.2015.

What do you mean?

Re: dynamic date

maternmi — Thu, 29 Jan 2015 14:30:10 GMT

Hi Andrei,

As expected the result is 01 2015. Do you or somebody else have any other idea?

Michael

Re: dynamic date

maternmi — Thu, 29 Jan 2015 15:21:53 GMT

Hi Andrei,

finally you helped me with your answer. I only add one "shift" paremeter (=1) more with result it shows me the first month of the following quarrter.)

LOAD

...

date(QuarterStart(today(),1),'MM.YYYY') as [Dynamic Month Year]

FROM datasource;

Thanks!