Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with calculated expressions in a table

I need to create a table like the one I attach in Excel. How can I do this?

Thank you

13 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Carmen,

The expression SUM ( {$}IMPORTE_MOVIMIENTO),0,RowNo() ))  will not work . because we cant put anything outside the sum function and here you are doing that.


so instead of the above expression Put sum(IMPORTE_MOVIMIENTO) you will get the results as you want. and please refer my last post.

Regards,

Nilesh Gangurde

Not applicable
Author

Nilesh,

But I have to restrict IMPORTE_MOVIMIENTO to a time frame. It’s because of that tat I put SUM ( {$}IMPORTE_MOVIMIENTO).

Is there any way to get the result with the restriction?

Thanks in advance

nilesh_gangurde
Partner - Specialist
Partner - Specialist

If you want the results with restrictions then put the table as which i suggested you in the above post.

And also put the list box for the date and then put the slections in the list box and you will get the results as per your selections.

OR

if You want to see the results for the perticular date in the hardcoded form then you can use the following script in the expression.

sum({<DateField = {"1/1/2012"}>} IMPORTE_MOVIMIENTO)

The above expression will give you the data for the 1/1/2012.

Regards,

Nilesh Gangurde

Not applicable
Author

It’s because of that that I put amount as SUM ( {$}IMPORTE_MOVIMIENTO),0,RowNo() ))

It must be a problem of communication, not being English my mother language. I send you a snapshot of the results, being Importe Amount and Importe Acumulado Accumulated Amount.

Thanks in advance