topic Re: Table Column Computations in QlikView

Table Column Computations

Thu, 06 Dec 2012 21:08:40 GMT

Hi everyone!

I have a problem where in a straight table. I have a new column that is computed through the values of 2 other columns.

Example: Column1 is Sales Gross Margin; Column 2 is Inventory Gross Margin; Column 3 is the difference between Sales and Inventory Gross Margin.

For the initial formula for Column 3, I used the headers:

[Sales Gross Margin] - [Inventory Gross Margin]

This formula works. However, the column headers may change depending on which language was selected. I use FieldValue to get the appropriate translation for "Sales Gross Margin" and "Inventory Gross Margin". However, I can't figure out how what to do so that the formula above would be arbitrary to the current translation. For example: If the current language is Spanish, the formula above would have the Spanish header for "Sales Gross Margin" and "Inventory Gross Margin".

Thanks for all the help!

Re: Table Column Computations

MayilVahanan — Thu, 06 Dec 2012 21:12:30 GMT

Try

= Column(2 )- Column(3)

Edit

Sorry, i miss bracket.. Thanks vlad,.

Re: Table Column Computations

Thu, 06 Dec 2012 21:24:20 GMT

Hi Mayil,

It didn't work. I think the name of the column headers should be used in the formula.

Re: Table Column Computations

vgutkovsky — Thu, 06 Dec 2012 21:34:51 GMT

Slight change to the above syntax: column(2) - column(3)

Regards,

Vlad

Re: Table Column Computations

Thu, 06 Dec 2012 22:27:03 GMT

Hi Vlad and Mayil,

It doesn't seem to work. Will column(2) - column(3) still work even if I have certain labels as headers?

Re: Table Column Computations

MayilVahanan — Thu, 06 Dec 2012 22:30:47 GMT

Yes, it taken the value from column 2 and column3 and subtract it. It doesn't consider the label of the expression.

Re: Table Column Computations

vgutkovsky — Thu, 06 Dec 2012 22:45:45 GMT

Make sure the columns actually exist and are not conditional. Column(2) - column(3) means the 2nd and 3rd expressions that are active.

Vlad

Re: Table Column Computations

Thu, 06 Dec 2012 23:04:09 GMT

Thanks Mayil and Vlad!

Re: Table Column Computations

vgutkovsky — Thu, 06 Dec 2012 23:17:51 GMT

No problem, please verify correct answer(s).