Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated columns and tag object

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

0 Replies