topic Re: Newbie question in QlikView

Newbie question

Thu, 02 Oct 2014 17:06:55 GMT

Hello everyone,

I am completely new to Qlikview. I am familiar with Crystal reports; however, Qlikview seems much more fun.

I am trying to do some simple stuff but I really couldn't find anything on the internet how to do what I want.

I simply want to sum each row. I am not sure if my data table is the problem here but I couldn't figure this out.

Here how my data table looks like:

I just want to do a straight table and would like to show totals for sales amount per row.

This is what I have tried and could not get anything:

Any help is appreciated.

Anonymous — Thu, 02 Oct 2014 17:45:04 GMT

Hi:

This is what you need ??

carvalguil — Thu, 02 Oct 2014 17:46:12 GMT

Have you tried something like:

Sum([2012 Sales] + [2013 Sales] + ...)?

Just make sure all your columns are 0 (zero), not null.

Thu, 02 Oct 2014 17:49:20 GMT

Ok. Thank you so much. I was using a wrong operator for sum function.