Extra column (expression with difference) in horizontal straight table

[bartvanwetten]

Dear all,

I have following challenge. In attached QlikView document you'll find a horizontal straight table. Now I want to have a third column per month wich shows me the difference between 'resultaat' and 'prognose'.

Can anyone help me out on this one?

Thank you all in advance.

Bart

[Digvijay_Singh]

Don't have license to access qvw, just thought of suggesting in case you tried Column(1)-Column(2)  kind of expression.

[#3]

Hey Bart

Did you figure this out?  I'm facing the same problem right now.

I've tried creating a crosstab in the script, using this The Crosstable Load but I have more than one column to add, and I jsut couldn't make this work.

Cheers

Lisa

[sunny_talwar]

Do you have a sample data you can share?