topic Re: Difference in Horizontal Straight Table in QlikView

Difference in Horizontal Straight Table

bartvanwetten — Mon, 04 Jul 2016 15:04:26 GMT

Dear all,

I have the following challenge.

How can I add a third column labeled 'Difference', in the horizontal straight table in the attachment, which shows me the difference between 'Resultaat' and 'Prognose'?

Thank you all in advance!

Bart.

Re: Difference in Horizontal Straight Table

Anonymous — Mon, 04 Jul 2016 15:12:42 GMT

Hi Bart

I would have thought you could just create a new expression using the previous expression labels. Assuming your first expression is 'Resultaat' and expression two is 'Prognose' then you can create expression 3 [Resultaat]-[Prognose] or the other way around as necessary and label this 'Difference'.

Kindest Regards

Brian

Re: Difference in Horizontal Straight Table

Tue, 05 Jul 2016 02:20:11 GMT

Hi,

Please check the attachment on sheet1 to see if this is what you're looking for. i've just done for the the first 3 expressions, you can continue the rest.

another option is add the difference column in script, with the prognose column value -prognose. It's a bit hard to explain as I don't have the

Re: Difference in Horizontal Straight Table

bartvanwetten — Tue, 05 Jul 2016 05:47:08 GMT

Hi Nhu,

you have made my day! I'll use the solution!

Kind regards,

Bart