topic Re: How to add mathematical function ?? in QlikView

How to add mathematical function ??

Tue, 30 Dec 2014 10:49:01 GMT

I have sales of 12 months but in different columns and I want to add them all in a column as Month and also wants to perform the sum of sales of that. So how can I perform ??

This is current data and wants to make chart as like this :-

Re: How to add mathematical function ??

Anonymous — Tue, 30 Dec 2014 11:18:38 GMT

You can use the cross table concept for this

Like this

[Month Sales]:

CrossTable(Month, Sales)

LOAD Department,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM

[Data Files\Excel\cross table.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: How to add mathematical function ??

Anonymous — Tue, 30 Dec 2014 11:20:43 GMT

Select the Line chart and

Dimension is Month

Expression is Sum(Sales)

Re: How to add mathematical function ??

Tue, 30 Dec 2014 11:41:08 GMT

Thanks to u all..

But I want to use without CROSS TABLE. Is any method without Cross table ????

Re: How to add mathematical function ??

Anonymous — Tue, 30 Dec 2014 11:46:47 GMT

try with the Pivot table

Dimension is Month

Expression is Sum(Sales)

after finish the chart drag the month to upwards...

Re: How to add mathematical function ??

Tue, 30 Dec 2014 11:59:05 GMT

Thanks..

But I want to make a line chart,, So plz suggest for that..

Re: How to add mathematical function ??

Anonymous — Tue, 30 Dec 2014 12:12:59 GMT

Take line char and add

Dimension is Month

Expression is Sum(Sales)

Re: How to add mathematical function ??

MarcoWedel — Tue, 30 Dec 2014 23:23:47 GMT

Why don't you want to use a crosstable load?

Re: How to add mathematical function ??

Wed, 31 Dec 2014 09:16:23 GMT

Thanks to u all.. We cant use this without Cross Table..

If anyone know how to do it without Cross Table then plz tell me..

Thanks again.

Re: How to add mathematical function ??

alkesh_sharma — Wed, 31 Dec 2014 09:20:42 GMT

USe crosstable function

Re: How to add mathematical function ??

MarcoWedel — Wed, 31 Dec 2014 13:49:10 GMT

If you don't explain why crosstable load is no option for you, we possibly won't be able to help...