Discussion Board for collaboration on QlikView Scripting.
I have a 'Month' field and a 'Date' field in one load table and various values for each of the 12 months in another load table. I want to get the value from this table based on the 'Date' field
I want to do something like
if (Month = 1, Jan_value, if (Month = 2, Feb_value,....)
Can you suggest a way of doing this?
Hi Srikanth, First you need to join these 2 tables, after that you need to write IF cond in the Resident Load.
Try to rename the Jan value to Jan etc..
Then try to use the Crosstable wizzard, it will bring back your table from a matrix form to a simple form.
Then you could link the table via the new month field.
Have a look at this, might be of help for you