topic Re: Multiplying two fields in a expression! in QlikView

Multiplying two fields in a expression!

Fri, 18 Feb 2011 09:53:27 GMT

Imagine if Date is there are as a dimension in line chart and I want some to have some below in the expression. Is it possible?


Sales * Count(ID) //Where Sales and ID are the fields.

I tried something same like above but it is not giving any value. Is there is anyother way of doing it please.

Hope some can help me out.

Multiplying two fields in a expression!

maneshkhottcpl — Fri, 18 Feb 2011 10:01:06 GMT

Hi,

Please explain ur problem in details. What are the dimenssions, we can use the aggr function also.

Can u post some sample application?

Thanks

Multiplying two fields in a expression!

tresB — Fri, 18 Feb 2011 10:01:10 GMT

i think you are missing SUM function. try : Sum(Sales)*Count(ID)

Regards, tresesco

Multiplying two fields in a expression!

maneshkhottcpl — Fri, 18 Feb 2011 10:07:00 GMT

HI,

Or use Sum(Sales*aggr(Count(ID),Dimenssion))

Multiplying two fields in a expression!

Fri, 18 Feb 2011 10:16:27 GMT


tresesco wrote:
i think you are missing SUM function. try : Sum(Sales)*Count(ID)

I have already tried that but it giving in correct result.

If try that as per your suggestion, where Sales=306 and ID=1244.

There result should be 306 * 1244 = 380664 but where as if I try as per your suggestion it is giving 14845896.

Multiplying two fields in a expression!

Fri, 18 Feb 2011 10:19:27 GMT


Manesh wrote:
Please explain ur problem in details. What are the dimenssions, we can use the aggr function also.
Can u post some sample application?<div></div>

Thanks!

Dimension is a Date. I think if you look into the below reply you should get to know what I am looking for. If not please let me know.

Multiplying two fields in a expression!

maneshkhottcpl — Fri, 18 Feb 2011 10:23:10 GMT

Hi,

Please check the frequency of Sales.

send me ur applicatio (Sample).

Multiplying two fields in a expression!

tresB — Fri, 18 Feb 2011 10:36:06 GMT

Are you trying : Sum(Sales) * Count (ID) (count would count the occurance/ frequency of ID, it would not give you ID value) OR,

Sum(Sales*ID) OR Sum(Sales) * ID All are very much different. it depends on your data and your requirement. if it is getting you confused, please upload your sample application as suggested by Manesh.

Regards, tresesco

Multiplying two fields in a expression!

Fri, 18 Feb 2011 10:39:11 GMT


Manesh wrote:
Please check the frequency of Sales.
send me ur applicatio (Sample). <div></div>

Above sugggestion also didn't work. I am sorry I cannot attach the sample application. I think you can use your own data that you have to work on it.

Multiplying two fields in a expression!

deepakk — Fri, 18 Feb 2011 10:44:59 GMT

hi Attitue,

I think it should be Sum(Sales) * count(distinct ID)

Multiplying two fields in a expression!

Fri, 18 Feb 2011 10:55:33 GMT


Deepak Kurup wrote:
I think it should be Sum(Sales) * count(distinct ID)<div></div>

Thanks but it didn't work 😞

Multiplying two fields in a expression!

deepakk — Fri, 18 Feb 2011 11:01:00 GMT

hi Attitude,

It did work ?? or didnt work ??.. if it didnt work.. Then create two separate expression and check the values. and in third expression add column(1) * Column(2).

I think there might be an issue in the data model,

Multiplying two fields in a expression!

suniljain — Fri, 18 Feb 2011 11:09:25 GMT

pls Check whether link is perfect between this field.

can you post application with limited data ?.

Multiplying two fields in a expression!

Fri, 18 Feb 2011 11:13:25 GMT

Have attached the sample now. Please check and let me know some solution.

Multiplying two fields in a expression!

suniljain — Fri, 18 Feb 2011 11:33:51 GMT

Dear

Pls check and Reply

Multiplying two fields in a expression!

Fri, 18 Feb 2011 12:15:42 GMT


Sunil Jain wrote:
Pls check and Reply<div></div>

Give me some time. I will check and get back to you

Multiplying two fields in a expression!

Fri, 18 Feb 2011 12:22:32 GMT

Why there is no data in the chart? Can you please check and let me know

Multiplying two fields in a expression!

deepakk — Fri, 18 Feb 2011 13:03:17 GMT

hi Attitude,

Just need a clarification. I goan through your data and I was finding it diffcult to understand the data.

you data looks like.

Field1 Field2 ID Year Month Sales

A X 1 2009 X3 6

A X 1 2009 S3 6

Now in the above case if you look the month is getting repeated twice.

As per you output you require only Sales as 6 for which you are writing in Expression Sales

and if we make Sum(Sales) the value becomes 12 which you said is wrong.

There is something wrong either in the data or in the way we are analyzing.

Multiplying two fields in a expression!

maneshkhottcpl — Mon, 21 Feb 2011 12:07:52 GMT

Hi,

I think u r not explaining the problem / situation correctly. This is not a big issue.

Then also u can try

sum(Distinct SALES)*Count(ID)

aggr(sum(Distinct SALES),ID)*Count(ID)

And revrt back , we are curious to see the solution.

Multiplying two fields in a expression!

Mon, 21 Feb 2011 12:56:55 GMT

Hi Manesh

Got stuck with some issues. Thats why I couldn't respond to you properly. Will get back to you very soon.