topic Re: Last 48 Hours Data in dashboard in QlikView

Last 48 Hours Data in dashboard

sspawar88 — Mon, 17 Aug 2015 05:39:37 GMT

How We can take last 48 hours data in dashboard?

How can we do it in Script?

Load

date(txn_time,'DD-MM-YYYY') as "Date",

timestamp(txn_time,'DD-MM-YYYY hh:mm:ss') as "Timestamp",

"txn_time"

FROM [lib://QVD/Data.QVD]

(qvd);

Can i do it on Dashboard?

suppose i have pie chart and Expression is:

Count({$<param_name={'TEMP'},param_value={'<=-20'},loc_subtype-={'2'},branch_type={'FACTORY'}>}param_value)/

Count({$<param_name={'TEMP'},branch_type={'FACTORY'},loc_subtype-={'2'}>}param_value)

can we do directly in this expression around "txn_time" ? how?

Re: Last 48 Hours Data in dashboard

sunny_talwar — Mon, 17 Aug 2015 05:45:31 GMT

Try this may be:

Load

date(txn_time,'DD-MM-YYYY') as "Date",

timestamp(txn_time,'DD-MM-YYYY hh:mm:ss') as "Timestamp",

"txn_time"

FROM [lib://QVD/Data.QVD]

(qvd)

Where TimeStamp(txn_time,'DD-MM-YYYY hh:mm:ss') >= Timestamp(Now() - 2, 'DD-MM-YYYY hh:mm:ss');

Re: Last 48 Hours Data in dashboard

sunny_talwar — Mon, 17 Aug 2015 05:49:21 GMT

May be this in your set analysis for the expression:

{<Timestamp = {"$(='>=' & TimeStamp(Max(Timestamp) - 2, 'DD-MM-YYYY hh:mm:ss') & '<=' & TimeStamp(Max(Timestamp), 'DD-MM-YYYY hh:mm:ss'))"}>}

Re: Last 48 Hours Data in dashboard

maxgro — Mon, 17 Aug 2015 06:08:07 GMT

Load

date(txn_time,'DD-MM-YYYY') as "Date",

timestamp(txn_time,'DD-MM-YYYY hh:mm:ss') as "Timestamp",

"txn_time"

FROM [lib://QVD/Data.QVD] (qvd)

where

Timestamp#(Timestamp, 'DD-MM-YYYY hh:mm:ss') <= now()

and

Timestamp#(Timestamp, 'DD-MM-YYYY hh:mm:ss') >= (now()-2)

;

Re: Last 48 Hours Data in dashboard

qlikviewwizard — Mon, 17 Aug 2015 06:15:56 GMT

Hi Please use the below script:

Thank You.

Data:
Load
    date(txn_time,'DD-MM-YYYY') as Date,
    timestamp(txn_time,'DD-MM-YYYY hh:mm:ss') as Timestamp,
    txn_time
FROM [lib://QVD/Data.QVD] (qvd)
where
  Timestamp#(Timestamp, 'DD-MM-YYYY hh:mm:ss') <= now() and Timestamp#(Timestamp, 'DD-MM-YYYY hh:mm:ss') >= (now()-2) ;