Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
luis_gmb
Partner - Contributor
Partner - Contributor

Creating dynamic dates in URLs

Hello friends. I have some questions.


1.- I have a URL where I just want the months and the year to change.


2.- When the month reaches 12, I want them to change to the next year.


Could anyone help me with this topic?


I leave the script:


vMaxMes = 12;

vMinMes = 1;

vMaxAño = 2017

FOR vMes = 1 to $(vMaxMes) - 1

Saidi:

LOAD @1 as [Mes],

  @2 as [Año],

  @3 as [Subdirección],

  @4 as [División],

  @5 as [Zona Distribución],

  @6 as [Usuarios Totales (Promedio) (#)],

  @7 as [DEMUA TIUT Sin Eventos (Minutos)],

  @8 as [DEMUA por Eventos TIUT (Minutos)],

  @9 as [DEMUA TIUT con Eventos (Minutos)],

  @10 as [TIUT Acumulado sin Eventos (Minutos promedio)],

  @11 as [TIUT Acumulado con Eventos (Minutos promedio)],

  @12 as [Meta TIUT (Minutos promedio)],

  @13 as [DEMUA SAIDI Sin Eventos(Minutos)],

  @14 as [DEMUA por Eventos SAIDI (Minutos)],

  @15 as [DEMUA SAIDI con Eventos (Minutos)],

  @16 as [SAIDI Acumulado sin Eventos (Minutos Promedio)],

  @17 as [SAIDI Acumulado con Eventos (Minutos Promedio)],

  @18 as [Meta SAIDI (Minutos Promedio)],

  @19 as [Usuarios Interrumpidos sin Eventos SAIFI (usuarios)],

  @20 as [Usuarios Interrumpidos por Eventos SAIFI (usuarios)],

  @21 as [Usuarios Interrumpidos con Eventos SAIFI (usuarios)],

  @22 as [SAIFI Acumulado sin Eventos (Interrupciones Promedio por Usuario)],

  @23 as [SAIFI Acumulado con Eventos (Interrupciones Promedio por Usuario)],

  @24 as [Meta SAIFI (Interrupciones Promedio por Usuario)],

  @25 as [Clave División],

  @26 as [Clave Zona],

  if(@27='Z','Zona',if(@27='D','División',if(@27='N','Nacional'))) as [Granularidad]

FROM

[http://10.4.13.50:5380/OperacionUtil-war/extractorTablaroIE?ANIO=$(vMaxAño)&MES=$(vMes)]

(txt, utf8, no labels, delimiter is '|', msq);

ENDIF

//STORE Saidi into (qvd);

NEXT

4 Replies
Anil_Babu_Samineni

Could be possible this case, Would you able to share more in detail please?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Sergey_Shuklin
Specialist
Specialist

Hi, Luis!

Try this:

vMaxMes = 13;

vMinMes = 1;

vMaxAño = 2017

FOR vMes = 1 to $(vMaxMes)

let vMaxAño=if($(vMes)=13,$(vMaxAño)+1,$(vMaxAño))

let vMes=if($(vMes)=13,1,$(vMes)) //there you must to prevent loading dates somehow because it will be loading your dates until crash.

// for instance you can use this condition within the loop before load statement: Exit For When $(vMes)=2 and $(vMaxAño)=2018.

luis_gmb
Partner - Contributor
Partner - Contributor
Author

Hello Anil the objective of this process is that by means of two variables year and month you can do an accountant from 1 to 12 that is the 12 months that has a year and when it reaches the last month change the year and start again always and When there is a link on the server.


With this you would automate the extraction of several data with a single link, without having to change the month and year manually.

luis_gmb
Partner - Contributor
Partner - Contributor
Author

Hello, Sergey.

Tomorrow I try this solution and tell you that it works.

Thank you.