topic Re: Reload specific file base on Calendar selection. in QlikView

Reload specific file base on Calendar selection.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I had list of QVD files which named as: Q12012016.qvd, Q12022016,

I would like to have Calendar object to select specific date and I want reload the QXXXXXX.qvd file based on User selection.

My QVD documents include many qvd files so it took time if I have to reload entire document.

Thanks for reading.

Re: Reload specific file base on Calendar selection.

girirajsinh — Mon, 09 Jan 2017 10:15:01 GMT

You may save the user selection ( calendar input here) to a variable and transform it to desired date format ( which is DDMMYYYY here)

Now you have the variable lets say vFileDate='12012016'

Use it while you load from qvd

load * from 'Q'&$(vFileDate)&'.qvd(qvd)'

and call Reload event

Something like that, I hope that would help you.

Re: Reload specific file base on Calendar selection.

vinieme12 — Mon, 09 Jan 2017 10:35:41 GMT

A dynamic filename would be

vFile = 'Q'&DATE(Today(),MMDDYYYY)&'.qvd';

vFilePAth = 'C:\Users\[user]\Downloads\'

You may change today()-1 or Today()-2, depending on your requirement

TABLE1:

LOAD *

FROM

[$(vFilePAth)&$(vFile)]

(qvd);

Re: Reload specific file base on Calendar selection.

Anonymous — Mon, 09 Jan 2017 10:40:51 GMT

Thank Girirajsinh, I am investigating the way the call Reload Event as you mentioned...

Re: Reload specific file base on Calendar selection.

Anonymous — Mon, 09 Jan 2017 10:43:05 GMT

Hmm, it does not show how to link between User Selection & Reload the specifiec qvd file. I think, trigger is a suggestion but I still get stuck...

Re: Reload specific file base on Calendar selection.

girirajsinh — Mon, 09 Jan 2017 11:02:04 GMT

could you use button to call Reload event once your variable is set for desired qvd to load ?

Re: Reload specific file base on Calendar selection.

Anonymous — Mon, 09 Jan 2017 11:13:56 GMT

Hello Girirajshinh,

It reloads entire documents and took much time. I need to reload the piece of script that load the necessary qvd file only.

Re: Reload specific file base on Calendar selection.

girirajsinh — Mon, 09 Jan 2017 11:25:16 GMT

You may choose option partial reload, if you need to append only that qvd..ofcourse you will have to change load script and put Prefix ADD Or REPLACE in load script

Or you may use "Control Statement" like if else or others

so decide that only part of your script gets executed depending on some variable which you will have to set based on Calendar selection / button press or something like that

I hope that provide you with some direction

Re: Reload specific file base on Calendar selection.

Anonymous — Tue, 10 Jan 2017 04:37:40 GMT

Girirajsinh, thanks for your quick response.

I could load specifiec qvd file after selecting the Calendar object but I must use File menu > Reload. I need to reload by button event or Calendar object when End User click/change on their browser.

Re: Reload specific file base on Calendar selection.

Anonymous — Tue, 10 Jan 2017 06:22:35 GMT

I came to conclusion that Qlikview could not load specific qvd file based on user selection at the front end. I have to work around: the only thing is load full data and using some section access.

This is similar post: loading different QVD files.

Wish that Qlikview could do better.