Discussion Board for collaboration related to Creating Analytics for QlikView.
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 :
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?
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 3Q_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
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..
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
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..