help needed

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

Hi All,

am using autonumber function to save the memory

am not sure at this situation it will be helpful.

Can someone help me out in this please??

test1:

LOAD

C_CODE,

E_CODE,

SP_CODE,

G_CODE,

P_REPORT_TO,

DOJ,

GR_CODE,

SEC_CODE,

OFF_CODE,

DH_DATE,

AutoNumber(Text(Trim(C_CODE))&'-'&Text(Trim(E_CODE))&'-'&Text(Trim(SP_CODE))&'-'&Text(Trim(G_CODE))&'-'&Text(Trim(P_REPORT_TO))&'-'&Num(Floor(DOJ))

&'-'&Text(Trim(GR_CODE))&'-'&Text(Trim(SEC_CODE))&'-'&Text(Trim(OFF_CODE))) as Key

FROM<>qvd;

Noconcatenate

test2:

Today:

LOAD

C_CODE,

E_CODE,

//SP_CODE,

G_CODE,

P_REPORT_TO,

DOJ,

GR_CODE,

//SEC_CODE,

OFF_CODE,

DH_DATE

FROM<>(qvd)

Where not Exists

(Key,AutoNumber(Text(Trim(C_CODE))&'-'&Text(Trim(E_CODE))&'-'&Text(Trim(SP_CODE))&'-'&Text(Trim(G_CODE))&'-'&Text(Trim(P_REPORT_TO))&'-'&Num(Floor(DOJ))

&'-'&Text(Trim(GR_CODE))&'-'&Text(Trim(SEC_CODE))&'-'&Text(Trim(OFF_CODE)))) and Num(Floor(DOJ))<>Num(Floor(Today()-1));

Re: help needed

tomasz_tru — Tue, 01 Aug 2017 06:22:08 GMT

This might be helpful when optimizing: Tools | Qlikview Cookbook

topic Re: help needed in QlikView

help needed

Re: help needed