Create dynamic dates qvd in qliksense

Aspiring_Developer — Thu, 01 Sep 2022 13:47:44 GMT

Hello All,

I have a table and I am loading the data everyday from SQL and storing into QVD's like below :-

LIB CONNECT TO '';

V_MASTER_SI_WF:

LOAD REPORT_DATE, // snapshot date
LOB,
ISSUENO,
ISSUELOGGER,
ISSUERECEIVED,
ISSUELOGGED,
ISSUECLOSED,
STATUS,
SAC,
SAC_NAME,
SAC_BILLING_TEAM,
CONTACTNAME,
CONTACTNO,
OWNINGID,
OWNERNAME,
ENQCOM,
NEXTKCI,
UPDATES_COUNT,
LASTTOUCHED_DATE,
DIARYDATE,
EMAIL,
SOURCESYSTEM,
PRODUCT,
QUERYTYPE,
REASON_FOR_CONTACT,
CAUSE,
ADJ,
ADJAMOUNT,
DISPUTEDVAL,
REMINDME,
SOURCEACC,
FIRSTDESTINATION,
FIRST_TEAM,
ISSUE_RECD,
ISSUE_LOGGED,
OPEN_AGE_DAYS,
OPEN_AGE_BAND,
OPEN_WKG_DAYS,
OPEN_WKG_DAYS_BAND,
LOGGING_ADVISOR,
QUEUE,
UNALLOQUEUEID,
OWNINGADVISOR,
OWNING_SITE,
OWNING_TEAM,
OWNER,
OWNING_MGR,
APPVERSION,
LASTTOUCHED_WKG_DAYS,
LASTTOUCHED_WKG_DAYS_BAND,
PROGRESS,
NEXTINVOICEDATE,
MPADATE,
OBITEAM,
MANAGER,
MANAGEDBY,
INTEXT,
LASTNOTEINPUTBY,
LASTNOTEDATE,
LASTNOTE,
OPENATCOP,
TRANSFERMTH,
REGION,
CLOSINGID,
ISSUE_CLOSED,
CLOSED_AGE_DAYS,
CLOSED_AGE_BAND,
CLOSING_ADVISOR,
CLOSING_SITE,
CLOSING_TEAM,
CLOSER,
CLOSING_MGR,
COPYBILLS,
MEDIUM,
ISSUETYPE,
RAG_STATUS,
SUMMARY,
QUEUENAME,
CUSTOMER_NAME,
ACCOUNT_NUMBER,
COMPANY_NAME,
ASSIGNEE,
REPORTER,
CATEGORY,
COMPONENT,
REQUESTED_DATE,
CREATED_DATE,
UPDATED,
RESOLVED,
CYCLE_TIME,
RESOLUTION,
DAYS_SINCE_LAST_COMMENT,
ISSUE_LINKS,
VOTES,
START_DATE,
REASON,
WORK_COMMENCED_DATE,
END_DATE,
COMPANY_NAME2,
ACCOUNT_NUMBER2,
QUERY_TYPE2,
CUSTOMER_REQUESTED_DATE2,
CONSEQUENCE,
FIRST_RESPONSE_DATE,
LAST_UPDATER,
PARTICIPANTS,
TRIGGER,
VULNERABILITY,
INVOICE_NUMBER,
INVOICE_NUMBER2,
LAST_NAME,
ORIGINAL_ESTIMATE,
ITEM_COUNT,
CHASE_DATE,
RECEIVED_FROM,
COUNTRY,
AMOUNT,
QUERY_ANALYSIS,
FILE_DATE,
AVG_LOGGED_TIME,
AVG_LOGGED_TIME_BAND,
CLOSED_WEEK_COMM,
CLOSED_WEEK_ENDING,
MTH,
COUNT,
ISSUE_CLOSER,
SEGMENTATION;

[V_MASTER_SI_WF]:
SELECT "REPORT_DATE",
"LOB",
"ISSUENO",
"ISSUELOGGER",
"ISSUERECEIVED",
"ISSUELOGGED",
"ISSUECLOSED",
"STATUS",
"SAC",
"SAC_NAME",
"SAC_BILLING_TEAM",
"CONTACTNAME",
"CONTACTNO",
"OWNINGID",
"OWNERNAME",
"ENQCOM",
"NEXTKCI",
"UPDATES_COUNT",
"LASTTOUCHED_DATE",
"DIARYDATE",
"EMAIL",
"SOURCESYSTEM",
"PRODUCT",
"QUERYTYPE",
"REASON_FOR_CONTACT",
"CAUSE",
"ADJ",
"ADJAMOUNT",
"DISPUTEDVAL",
"REMINDME",
"SOURCEACC",
"FIRSTDESTINATION",
"FIRST_TEAM",
"ISSUE_RECD",
"ISSUE_LOGGED",
"OPEN_AGE_DAYS",
"OPEN_AGE_BAND",
"OPEN_WKG_DAYS",
"OPEN_WKG_DAYS_BAND",
"LOGGING_ADVISOR",
"QUEUE",
"UNALLOQUEUEID",
"OWNINGADVISOR",
"OWNING_SITE",
"OWNING_TEAM",
"OWNER",
"OWNING_MGR",
"APPVERSION",
"LASTTOUCHED_WKG_DAYS",
"LASTTOUCHED_WKG_DAYS_BAND",
"PROGRESS",
"NEXTINVOICEDATE",
"MPADATE",
"OBITEAM",
"MANAGER",
"MANAGEDBY",
"INTEXT",
"LASTNOTEINPUTBY",
"LASTNOTEDATE",
"LASTNOTE",
"OPENATCOP",
"TRANSFERMTH",
"REGION",
"CLOSINGID",
"ISSUE_CLOSED",
"CLOSED_AGE_DAYS",
"CLOSED_AGE_BAND",
"CLOSING_ADVISOR",
"CLOSING_SITE",
"CLOSING_TEAM",
"CLOSER",
"CLOSING_MGR",
"COPYBILLS",
"MEDIUM",
"ISSUETYPE",
"RAG_STATUS",
"SUMMARY",
"QUEUENAME",
"CUSTOMER_NAME",
"ACCOUNT_NUMBER",
"COMPANY_NAME",
"ASSIGNEE",
"REPORTER",
"CATEGORY",
"COMPONENT",
"REQUESTED_DATE",
"CREATED_DATE",
"UPDATED",
"RESOLVED",
"CYCLE_TIME",
"RESOLUTION",
"DAYS_SINCE_LAST_COMMENT",
"ISSUE_LINKS",
"VOTES",
"START_DATE",
"REASON",
"WORK_COMMENCED_DATE",
"END_DATE",
"COMPANY_NAME2",
"ACCOUNT_NUMBER2",
"QUERY_TYPE2",
"CUSTOMER_REQUESTED_DATE2",
"CONSEQUENCE",
"FIRST_RESPONSE_DATE",
"LAST_UPDATER",
"PARTICIPANTS",
"TRIGGER",
"VULNERABILITY",
"INVOICE_NUMBER",
"INVOICE_NUMBER2",
"LAST_NAME",
"ORIGINAL_ESTIMATE",
"ITEM_COUNT",
"CHASE_DATE",
"RECEIVED_FROM",
"COUNTRY",
"AMOUNT",
"QUERY_ANALYSIS",
"FILE_DATE",
"AVG_LOGGED_TIME",
"AVG_LOGGED_TIME_BAND",
"CLOSED_WEEK_COMM",
"CLOSED_WEEK_ENDING",
"MTH",
"COUNT",
"ISSUE_CLOSER",
"SEGMENTATION"
FROM "ENQ_BI_QLIK"."V_MASTER_SI_WF";

Store V_MASTER_SI_WF into 'lib://.../Load/../.../V_MASTER_SI_WF_Today.qvd' ;
Store V_MASTER_SI_WF into 'lib://../Load/../../V_MASTER_SI_WF_30082022.qvd' ;

Currently, I am manually changing the dates everyday to store the data . So, is there any way to make it dynamic , so that I don't manually change the date from 3008200 to 31082022 ?

I think it can be done by using a variable , but I am not sure about the same ?

Can anyone please help me ?

Thanks in advance

Re: Create dynamic dates qvd in qliksense

Aurelien_Martinez — Thu, 01 Sep 2022 13:57:03 GMT

Hi,

You can create a variable like:

Let vDate = Date(Today(), 'DDMMYYYY');

and using it like :

Store V_MASTER_SI_WF into 'lib://../Load/../../V_MASTER_SI_WF_$(vDate).qvd' ;

Aurélien

topic Re: Create dynamic dates qvd in qliksense in App Development

Create dynamic dates qvd in qliksense

Re: Create dynamic dates qvd in qliksense