Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Newbie question

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:

Capture.JPG.jpg

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:

Capture 2.JPG.jpg

Any help is appreciated.

1 Solution

Accepted Solutions
Highlighted
New Contributor III

Re: Newbie question

Have you tried something like:

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

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

View solution in original post

3 Replies
Highlighted
New Contributor III

Re: Newbie question

Hi:

This is what you need ??

Highlighted
New Contributor III

Re: Newbie question

Have you tried something like:

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

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

View solution in original post

Highlighted
Not applicable

Re: Newbie question

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