topic Timebased production information to .qvw in QlikView

Timebased production information to .qvw

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

Hello.

Is there any chance to get value from all timebased tags as shown below? Now I get only lastest value.

SET v.nrp_starttime = '22.05.2016 7:00:00';
SET v.nrp_endtime = '23.05.2016 10:00:00';
SET v.nrp_interval = 5;
SET v.nrp_taglist = HISTORIAN01/SCADA2.JJ.JP.MATX.TIL3/INTERPOLATED, |HISTORIAN01/SCADA2.JJ.JP.MAT.SUL3/INTERPOLATED, |HISTORIAN01/SCADA2.JJ.JP.MAT.ERA3/INTERPOLATED, |HISTORIAN01/SCADA2.JJ.JP.MIT2011/INTERPOLATED;

TABLE1:
SQL SELECT StartTime,
EndTime,
Value1,
Value2,
Value3,
Value4,
from NOVOPlusConfiguration.dbo.nrp_HistorianTableFunctionIntervalString('$(v.nrp_starttime)','$(v.nrp_endtime)','$(v.nrp_interval)','$(v.nrp_taglist)');

Re: Timebased production information to .qvw

PrashantSangle — Tue, 31 May 2016 12:15:42 GMT

Hi,

did not get your question

check below time and date function in help menu might help you.

timestamp()

timestamp#()

date()

date#()

time()

time#()

monthName()

Year()

Day()

Month()

Regards,

Re: Timebased production information to .qvw

santiago_respane — Tue, 31 May 2016 12:24:54 GMT

Hi Timo,

What is the issue you are having?

Please be kind and elaborate more in order to solve your issue.

Kind regards,

Re: Timebased production information to .qvw

tka_ovako — Wed, 01 Jun 2016 06:10:01 GMT

Hello.

I mean that now I get values only from last tag: HISTORIAN01/SCADA2.JJ.JP.MIT2011/INTERPOLATED. Other 3 values are plank.

I managed to make own *.qvd from each tags and joined those to my qvw but is there chance to make it all in one qvw?