topic Expression in QlikView

Expression

bharatkishore — Tue, 28 Jun 2016 11:13:51 GMT

Hi All,

I have 2 fields Channel and Sales..

In channel i have A,B,C,D,E and in sales i have 10,20,30,40,50

Now my requirement is if i select a channel for example i selected A and it is having value 10.. i need to get 10/10+20+30+40+50..

The same for B.. 20/10+20+30+40+50 = 20/150..

Please help on this..

Thanks

Bharat

Re: Expression

MK_QSL — Tue, 28 Jun 2016 11:15:55 GMT

SUM(Value)/SUM(Total Value)

Re: Expression

bharatkishore — Tue, 28 Jun 2016 11:19:15 GMT

Hi Manish,

Thanks for your reply..

I have given like this

=sum(Spend)/sum(TOTAL Spend)

But i am getting value as 1

Re: Expression

Kushal_Chawda — Tue, 28 Jun 2016 11:22:22 GMT

Create the chart,

Dimension - channel

Expression - sum(sales) (check relative option for this expression)

Re: Expression

MK_QSL — Tue, 28 Jun 2016 11:24:49 GMT

Create a Chart/Table

Dimension

Channel

Expression

SUM(Value)/SUM(Total Value)

If you want in Text Box

You have to use

SUM({<Channel = {'A'}>}Value)/SUM(Total Value)

SUM({<Channel = {'B'}>}Value)/SUM(Total Value)

SUM({<Channel = {'C'}>}Value)/SUM(Total Value)

SUM({<Channel = {'D'}>}Value)/SUM(Total Value)

SUM({<Channel = {'E'}>}Value)/SUM(Total Value)

Re: Expression

Anonymous — Tue, 28 Jun 2016 11:25:13 GMT

if you are not using the expression in the chart then you need to ignore the filter for the denominator.

sum(Spend)/sum({<Channel =>}Spend)

use Bharat's expression in say a bar chart where the dimension is Channel. As indicated previously you should mark this as relative and probably also define the number format as %

Re: Expression

susovan — Tue, 28 Jun 2016 11:25:29 GMT

Hi Bharat,

Try this attachment,

Re: Expression

Anonymous — Tue, 28 Jun 2016 11:27:43 GMT

Hi,

use this expression :

NUM(SUM(Sales)/SUM(TOTAL Sales),'##.0000')

Re: Expression

susovan — Tue, 28 Jun 2016 11:30:43 GMT

Hi Bharat,

You also try this expression,

Sum(TOTAL{<Field1=>} Field2)/Sum(Field2)

Re: Expression

bharatkishore — Tue, 28 Jun 2016 11:32:43 GMT

Thanks Damian..This is exactly what i needed.