Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

how to add single values into existing table

Hey all,

I build a quite simple inline table at the beginning of my load script. The process runs dynamically, but finally the table looks similar to this. For the column of "value_03" I don't define any value, but I already create the column as a placeholder. 

yearcodevalue_01value_02value_03
2014EUR111
2015EUR111
2014USD1,321,35
2015USD1,111,25

During next steps in my load script I have a loop where I switch between different years and/or codes. During each run I calculate different values for the column "value_03". So Now I would like to add those values especially into that one field, depending on the actual year of the run, the "code" and the column "value_03". In fact in first run of the loop I calculate data for the year 2014 and for USD for coulmn value_03, in second for year 2015 and so on ...

So how can I do this? I tried with stuff like Joins, but I don't need to add whole coulmns or rows. I just want to edit/add that single value per each run.

Would be so glad about any help! Thanks a lot!

BR

0 Replies