topic Re: Doubts regarding expressions in QlikView

Doubts regarding expressions

Thu, 04 Apr 2013 15:45:59 GMT

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.

Re: Doubts regarding expressions

m_woolf — Thu, 04 Apr 2013 17:36:24 GMT

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

Re: Doubts regarding expressions

lvf — Thu, 04 Apr 2013 19:11:11 GMT

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.

Re: Doubts regarding expressions

Fri, 05 Apr 2013 06:43:44 GMT

Thank you very much to both of you.

With your suggestions, I got the expected output.