Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community memers,
I have problem in reloading data.The end user should be given the ability to decide how much data should be loading during data refresh.
example: 2 or 3 years of data should be asked to the user
Hi rameskmcs
Do you wnat select the reload period from web access AJAX / IEPlugign (Acces Point) or Desktop / Server reload?
Hi Marcos,
Thanks for your response, Actually I have 10 years of data, when the user reloads, it should ask for how many years of data you want to reload.
Regards,
rams
Qlikview never ask
Its not Possible.
but could b hard code like if you want ten years data .
Hi Ramesh,
Try this script
LET vValue = Input('Enter value', 'Input box');
Load
*
FROM Table
WHERE Year >= Year(Today(), $(vValue));
Hope this helps you.
Regards,
Jagan.
Hi Jagan,
Thanks for your resones, but I am getting below error.can you please tell me where the problem is.My table name
is Treat and my Year field name is Years.I have given the input value as 3 and got the following error
"Cannot open file 'E:\Qlikview\QV V10 Certification Project\Documentation\Treat
where Years>=Year' The filename, directory name, or volume label syntax is incorrect.
LOAD
*
From Treat
where Years>=Year(Today(),3) "
You need to change the 'From Table' line. That's just an example. Replace it with a reference to the file or an sql statement to get the data as appropriate to your situation
hi Waseenar I am getting below error can you please correct me
Error in expression:
Year takes 1 parameter
LOAD
*
from [..\QVd's\Treat.qvd]
(qvd)
Where Years>=Year(Today(),1999)
hi
'
Test:
Load *,Year(Col3) As Year Inline
[
Col1,Col2,Col3,Sales
RO_0001,S1,4/15/2010,100
RO_0001,S2,3/19/2012,200
RO_0001,S2,1/10/2011,300
RO_0002,S2,3/25/2010,400
RO_0002,S2,8/8/2012,500
RO_0002,S1,10/10/2019,600
RO_0003,S1,12/12/2009,700
RO_0003,S2,10/01/2012,800
RO_0003,S2,06/05/2011,900
RO_0003,S2,05/05/2009,1000
] Where Col2='S2';
LET vValue = Input('Enter value', 'Input box');
Y:
NoConcatenate
Load Year as Years,Col1 resident Test where Year = Year(AddYears(today(),-$(vValue)));
Hope it helps
Hi Ramesh,
Hope attached file helps you. It works for me.
Regards,
Jagan.