Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Computing from 2 tables

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

LOAD

...

Month,

Date

....

;

LOAD

...

Jan_value,

Feb_value,

...

;

I want to do something like

LOAD

if (Month = 1, Jan_value, if (Month = 2, Feb_value,....)

;

Can you suggest a way of doing this?

Thanks

2 Replies
Not applicable

Re: Computing from 2 tables

Hi Srikanth, First you need to join these  2 tables, after that you need to write IF cond in the Resident Load.

eruditio
Contributor III

Re: Computing from 2 tables

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

CrossTable.qvw

Community Browser