topic Re: How to calculate % and store in field in QlikView

How to calculate % and store in field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I need help. I have a data where i want to divide the sum(sales) and store it in Some values.

Ex:

I have Fields Cost center, Cost nature, parts, Sum

Here i need to filter for

Cost Center= Allocation %

Cost Nature= Variable pay

Parts= Pen cap

And total sum i have to divide by 70 % and store this value to New field for Pen

Total sum i have to divide by 30 % and store this value to New field for Pencil.

But here Pen and Pencil are exist in Cost Center field.

Could some one please help me.

Thanks in advance

Re: How to calculate % and store in field

sunny_talwar — Wed, 25 Jan 2017 12:28:04 GMT

Can you share a sample or sample data at least to show what you have and what you are looking to get?

Re: How to calculate % and store in field

Anonymous — Wed, 25 Jan 2017 14:33:19 GMT

Hi Sunny T,

Please find the details below

Here i have many fields and in first you can see Balance Period.

1. For Cost Center "ALLOCATION CLINKER 70 % & Grinding 30%" you can see some values in Balance Period for particular Equiv.

2. lets take an example. I will take Sum([ Balance period]) with selection of Allocation Clinker 70% **** and Variable Cash Cost and Equiv is Let's take Wear Parts.

The Sum([ Balance period]) this value i have to divide by 70 % and store it for Clinker Production and divide 30% and store it the value for Cement Grinding (WHich You can see in Cost Center).

This values i can store in new field.

Hope this helps to know more about the requirement.

Thanks in Advance

Re: How to calculate % and store in field

sunny_talwar — Wed, 25 Jan 2017 14:40:32 GMT

Where do you plan to use this variables in? In a chart or in a text box object or somewhere else?

Re: How to calculate % and store in field

Anonymous — Wed, 25 Jan 2017 14:46:26 GMT

Anything is fine. Chart could give more clarity.

Re: How to calculate % and store in field

sunny_talwar — Wed, 25 Jan 2017 14:51:20 GMT

So it should be something like this?

Variable1 = Sum([ Balance period])/0.70 or do you mean multiply? Sum([ Balance period])*0.70

Variable2 = Sum([ Balance period])/0.30 or do you mean multiply? Sum([ Balance period])*0.30

Re: How to calculate % and store in field

Anonymous — Wed, 25 Jan 2017 15:01:25 GMT

Yes it is Divide. Your Variable 1 is correct But it will work only on Text object.

When i select Clinker or Grinding the new field which we have created should display this new value for Wear Parts, corresponding to other like Diesal should display it's value (Sum(Balance)/.70 ) in new field.

Re: How to calculate % and store in field

sunny_talwar — Wed, 25 Jan 2017 15:07:20 GMT

Bro, its time you share a sample file. I have only bits and pieces idea of what you are looking for. Please help me so that I can help you.

Re: How to calculate % and store in field

Anonymous — Wed, 25 Jan 2017 15:31:31 GMT

Hi Sunny,

PFA of Data. Hope you can help me.

Re: How to calculate % and store in field

Anonymous — Fri, 27 Jan 2017 04:28:44 GMT

Hi Experts,

Please could you help me out on this.

Regards,

Varun K