topic Re: Combining measures in single expression in QlikView

Combining measures in single expression

nareshthavidishetty — Mon, 23 Nov 2015 06:32:26 GMT

Hi,

How to bring 3 product sales in one expression.

Ex: i have 3 products like A,B,C

I have created a pivot table , in the expression in need overall sales like sales (A+B+C)

can anyone give the expression for this

Re: Combining measures in single expression

tamilarasu — Mon, 23 Nov 2015 06:35:44 GMT

Hi Naresh,

Just write, Sum(Sales). What is your dimension.?

I assume that all you have Product as dimension and Sales filed as expression in pivot table.

Re: Combining measures in single expression

raghvendrasingh — Mon, 23 Nov 2015 06:40:03 GMT

Hi Naresh,

Please provide complete requirement, What you actually want to see?

Regards,

Raghvendra

Re: Combining measures in single expression

Anonymous — Mon, 23 Nov 2015 06:40:30 GMT

Is this you want??

Product Sum(Sales)

A 1400

B 500

C 600

Re: Combining measures in single expression

nareshthavidishetty — Mon, 23 Nov 2015 06:49:22 GMT

ii need like sum(A+B+C) ie., over all sales

Re: Combining measures in single expression

Siva_Sankar — Mon, 23 Nov 2015 06:49:33 GMT

PFA

Re: Combining measures in single expression

settu_periasamy — Mon, 23 Nov 2015 06:54:15 GMT

Hi Naresh,

Try this..

=sum(TOTAL Sales)

you can include your dimension, if you want.. like

=Sum(TOTAL <Year> Sales)

Re: Combining measures in single expression

Anonymous — Mon, 23 Nov 2015 06:56:02 GMT

You can try like:

sum(A)+sum(B)+sum(C) as TotalSales

Re: Combining measures in single expression

Mark_Little — Mon, 23 Nov 2015 12:17:30 GMT

Hi,

SUM({Product={'A','B','C'}}Sales) Would sum the sales for Product A, B and C

Then

SUM({Product-={'A','B','C'}}Sales) Would sum the sales for all Products except A, B and C

Mark

Re: Combining measures in single expression

HirisH_V7 — Mon, 23 Nov 2015 12:30:47 GMT

Hi,

Marks expression helps you .

Thanks,

hirish