Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Missing Date Values from Master Calendar

Dear All,

Please check my attached QV file and the source excel file. I have sort the TARIH field with below statement:

LOAD * RESIDENT EXCEL1 ORDER BY TARIH ASC;

But my master calendar doesn't catch the 2000 and 2001 years. I think that it is related with my below variable.

LET varMinDate = Num(Peek('TARIH', 0, 'zrapor_genel.xls'));

Because it only catch "08.06.2002" date as a minimum TARIH value but it is not the minimum one.

I'm looking for your great support.

Best Regards,

Asim Akin

Tags (1)
1 Solution

Accepted Solutions

Missing Date Values from Master Calendar

Hello Asim,

I'd change your code to look like

OrderedDatesTable: //ChangedLOAD TARIH RESIDENT EXCEL1 ORDER BY TARIH ASC; //ChangedLET varMinDate = Num(Peek('TARIH', 0, 'OrderedDatesTable')); //ChangedLET varMaxDate = Num(Peek('TARIH', -1, 'OrderedDatesTable')); //Changed


And adding at the end of the tab

DROP TABLE TempCalendar;DROP TABLE OrderedDatesTable; //Changed


5 Replies

Missing Date Values from Master Calendar

Hello Asim,

A little misunderstanding here. Peek looks into Qlikview tables, not Excel files nor any other files or sources. So

OrderedDatesTable:LOAD * RESIDENT EXCEL1 ORDER BY TARIH ASC;LET varMinDate = Num(Peek('TARIH', 0, 'OrderedDatesTable'));LET varMaxDate = Num(Peek('TARIH', -1, 'OrderedDatesTable'));


Will do what you want.

Regards.

Not applicable

Missing Date Values from Master Calendar

Hello Miguel,

Did you try it with success? It doesn't work on my QV 8.5. I still cannot see years 2000 and 2001.

Best Regards,

Asim Akin

Missing Date Values from Master Calendar

Hello Asim,

I'd change your code to look like

OrderedDatesTable: //ChangedLOAD TARIH RESIDENT EXCEL1 ORDER BY TARIH ASC; //ChangedLET varMinDate = Num(Peek('TARIH', 0, 'OrderedDatesTable')); //ChangedLET varMaxDate = Num(Peek('TARIH', -1, 'OrderedDatesTable')); //Changed


And adding at the end of the tab

DROP TABLE TempCalendar;DROP TABLE OrderedDatesTable; //Changed


Not applicable

Missing Date Values from Master Calendar

Hello Miguel,

Thanks for your always prompt support. I want to ask another question without changing the topic. I want to present the total values of Acilan and Cozulen, but the chart shows the double times of those values. What can be the reason of that?

Best Regards,

Asim Akin

Not applicable

Missing Date Values from Master Calendar

Please ignore my last question. Your solution fixed it.