topic Computing from 2 tables in QlikView

Computing from 2 tables

Mon, 27 Jan 2014 16:46:11 GMT

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

Re: Computing from 2 tables

Mon, 27 Jan 2014 17:34:54 GMT

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

Re: Computing from 2 tables

Anonymous — Mon, 27 Jan 2014 17:39:56 GMT

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