Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubts regarding expressions

Hi guys,


Please find the attached screen shot first (with the name Issue-1). I am following the same procedure but could not get the same output.

You can see in the screen shot, how author has shown the populated table. While in my case, data is not getting populated in the table.   All I am getting is a table with headers and no data.

Here is what I did :

1. Author has mentioned 4 expressions to add.  I added first one in expression box. Clicked on NExt and added it's label. Clicked on OK .

2. To add 2nd expression, I right clicked on the chart ---->Properties---> Expressions Tab ---> Clicked on OK.  Added expression. Added it's label ..

And in the same way I added 4 expressions. Then I did rest all as mentioned in the attached screen shot ( That is , total mode to NO Totals etc).

My doubts :

1. Have I used correct method to add all 4 expressions ( the way I described above)?  ( I have also attached screen shot of my expressions )

2. If you see last line of author in the screen shot, he has mentioned click on FINISH.  However, I did not see finish button with the way I added my expressions.

3. Red dotted light comes below my expression :   Flights: Sum ([# Departures Performed])       .   Is there any syntax mistake?

Thanks.

1 Solution

Accepted Solutions
lvf
Employee
Employee

You have created each expression in an individual Edit Expression which is correct.  However your expressions should read like the following:

     Sum([# Departures Performed])

    

     Sum([# Transported Passengers])

You've just included the expression label/name in the expression,  thus syntax error as indicated but the red line.

View solution in original post

3 Replies
m_woolf
Master II
Master II

The word "Flights:" should not be part of the expression.

lvf
Employee
Employee

You have created each expression in an individual Edit Expression which is correct.  However your expressions should read like the following:

     Sum([# Departures Performed])

    

     Sum([# Transported Passengers])

You've just included the expression label/name in the expression,  thus syntax error as indicated but the red line.

Not applicable
Author

Thank you very much to both of you. 

With your suggestions, I got the expected output.