Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reload problem with inputfields

Hi,

I have a qvw with some inputfields, the problem is that somethimes the reload of this file fails at the end of the script, when this hapens I have to comment the input fields in my script, reload and save the document, then I uncomment the inputfields and reaload again without any problem. After this process I can reload the file without problem but some time later (hours, days) the problem appears randomly.

Does anyone know if this is a bug or how I can solve this problem?

Thank you!

Tags (1)
6 Replies
vgutkovsky
Honored Contributor II

Reload problem with inputfields

Hi, Gabriela. This v10 bug also had me stumped. See Alecsandru's post here, fixed the problem for me: http://community.qlik.com/message/87900

Regards,

Vlad

Not applicable

Reload problem with inputfields

Hi Vlad,

Thanks for the response, I already have a unique key for my inputfields. But still the reload fails sometimes without a reason.

Regards!

vgutkovsky
Honored Contributor II

Reload problem with inputfields

No, not just a unique key, specifically the rowno function! This is a totally weird hack, but for some reason it works!

Not applicable

Reload problem with inputfields

Vlad, I'm using the rowno() function. I think this is a different problem.

//my script here:

Facts:

LOAD RowNo() as ID,

           CLIENTE,

     ARTICULO,

     FECHA,

     [Venta Kilos],

     [Venta Monto],

     [Costo Venta],

     [Gastos Indirectos],

     [Gastos Directos]

FROM

[..\Transform\Facts\FactsWIVentas.qvd]

(qvd);

INPUTFIELD [Venta Kilos WI], [Venta Monto WI], [Gastos Indirectos WI], [Gastos Directos WI], [Costo Venta WI];

Inputfields:

LOAD RowNo() as ID,

           [Venta Kilos] as [Venta Kilos WI],

     [Venta Monto] as [Venta Monto WI],

     [Costo Venta] as [Costo Venta WI],

     [Gastos Indirectos] as [Gastos Indirectos WI],

     [Gastos Directos] as [Gastos Directos WI]

FROM

[..\Transform\Facts\FactsWIVentas.qvd]

(qvd);

Regards!

vgutkovsky
Honored Contributor II

Reload problem with inputfields

Oh, I don't think you can use QVDs or RESIDENT for input fields anymore either. They are really limiting the functionality! You need to read from a CSV or XLS. So in my scripts, after I generate a calendar, I output to CSV, drop the table, then read it back in to QV with the rowno function. So:

calendar:

....

STORE calendar into calendar.csv (txt);

DROP TABLE calendar;

inputfield dateset;

calendar:

LOAD

        date as dateset,

        rowno() as tempfield

FROM calendar.csv (txt);

DROP FIELD tempfield;

dasilva
New Contributor

Reload problem with inputfields

Hi Gabriela! Did this work in earlier versions of QV10 or QV9? I'm experiencing the same problems; the reload works fine for a period, and then suddenly it crashes and I have to make the same steps as you mention... Have you reported this to QT?

Community Browser