topic calculated columns and tag object in QlikView

calculated columns and tag object

Thu, 27 Aug 2009 20:42:25 GMT

Hello,

I have two questions:

Question 1:

How do you make calculated columns? Is it correct to do this in the script? I want to calculate the discount capex over the projects. something like this:

LOAD

sum([Capex] / ((1 + 0.1) ^ ([Year] - 2009))) as Discount Capex

SQL SELECT Capex,ProjectName

FROM

quintus2009.dbo.ProjectPortfolio

GROUP

BY ProjectName ;

But I get an error about missing '(' ???

Question 2:

Is it possible to create a tag object in Qlikview. With the tag object you can create temporally an selection of values which are in scope. example: scope In / Out

You can use the tag object in graphics

Regards,

Wouter Dijkstra

calculated columns and tag object

Thu, 27 Aug 2009 22:05:09 GMT

What is the ^ used for in this instance?

calculated columns and tag object

Thu, 27 Aug 2009 22:10:25 GMT

Hello Carney,

^ means to the power. I found the formula but i my questions are still a live.

The formula :

sum

(Capex / pow((1 + 0.1),(Year - 2009))) as DiscountCapex

regards

Wouter