Calculated columns and tag object

Thu, 27 Aug 2009 20:46:11 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

topic Calculated columns and tag object in QlikView

Calculated columns and tag object