Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How I can automatically add an expression when there is a new record added to source table?

I have two tables one has types(ucode_rp_type) other has values(uadj_amt).

I want to sum uadj_amt by uadj_code which belongs to certain ucode_rp_type . Each uadj_code should be in one column.

I could do this by writing an expression for each codekey  :

Sum ({$<ucode_rp_type={'6'},codekey={'STD-COGS'}>}uadj_amt)

My question is how can I automatically add a column when there is a new codekey added to ucode_rp_type in Q_UCODE table?

Q_Uadj:

Load

  uadj_amt,
 
uadj_code  as codekey,
  uadj_part  as partkeyuadj,
   upper("uadj_tr_type") as uadj_tr_type;

SQL SELECT
    "uadj_amt",
    "uadj_code",
     "uadj_part",
    "uadj_tr_type",
FROM PUB."uadj_det" where "uadj_year"=year(sysdate());

for i = 1 to 3

Q_UCODE:

Load ucode_ccode as codekey ,
    
ucode_desc ,
     subfield(ucode_rp_sign,',',$(i)) as ucode_rp_sign,
     subfield(ucode_rp_type,',',$(i)as ucode_rp_type;
SQL SELECT "ucode_ccode",
    "ucode_desc",
    "ucode_rp_sign",
    "ucode_rp_type"
FROM PUB."ucode_mstr";
next

Thanks

Tags (2)
3 Replies
sujeetsingh
Honored Contributor III

Re: How I can automatically add an expression when there is a new record added to source table?

Bay,

It seems that  it is a complex issue...but i want to make some facts clear--

---you want that whenever your source file have a new Key added it is automatically called it set analysis...

Please explain ...

And try to post a sample file..

Not applicable

Re: How I can automatically add an expression when there is a new record added to source table?

Hi,

You undestood me correctly, I want that whenever my source file have a new Key added it is automatically called it set analysis.

My sample files can be reached from below link

https://www.dropbox.com/sh/0eilqj3z9cco3pu/agCuCUoTzb

Thanks,

RB

sujeetsingh
Honored Contributor III

Re: How I can automatically add an expression when there is a new record added to source table?

Bay,

The first thing which you need to add is to add a date field of updation of keys...

And then one can find of the minimun difference of tha update field and ReloadTime() field..

Community Browser