topic Re: Caluclate 80-20% in backend in QlikView

Caluclate 80-20% in backend

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

Dear Team,

i stuck a requirement. i have three field item number Branch QTY. For this i am sharing data.

Requirment is:my Branch Field contain Delhi,Mumbai,Hydrabad,Banglore,

I want to caluclate Which qty exist in Delhi is divided in 80% in D1 AND 20% D2

Same For Mumbai IN 80% IN M1 AND 20%M2

Same For Hydrabad IN 80% IN H1 AND 20%H2

Same For BangloreIN 80% IN B1 AND 20%B2

Re: Caluclate 80-20% in backend

prat1507 — Thu, 03 Aug 2017 07:50:34 GMT

Hi Can you please be a little more clear as to where you need D1, D2,.....?

Regards
Pratyush

Re: Caluclate 80-20% in backend

panipat1990 — Thu, 03 Aug 2017 07:52:53 GMT

Store 80% in D1 And Store 20% in D2 Of Total QTY IF branch is delhi

Re: Caluclate 80-20% in backend

kusumanchir — Thu, 03 Aug 2017 08:14:46 GMT

Hi Gourav,

Please find the attached app and let me know if it is an expected output.

Re: Caluclate 80-20% in backend

balar025 — Thu, 03 Aug 2017 08:22:02 GMT

Hi,

You have to make 2 load of same data file. One for 80% and second for 20% as below

Load *,

left(State,1)&1 as Store,

Qty*0.8 as QtyNew

Resident Data;

Load *,

left(State,1)&2 as Store,

Qty*0.2 as QtyNew

Resident Data;

It will autoconcate your data.

Regards,

Ravi

Re: Caluclate 80-20% in backend

panipat1990 — Thu, 03 Aug 2017 08:22:55 GMT

Dear Sir,

But i want to make D1 D2 AND M1 M2 AND B1 B2 Field Value.

If i select Delhi then it Selected D1 D2 Same AS Mumbai,Banglore

Re: Caluclate 80-20% in backend

balar025 — Thu, 03 Aug 2017 08:28:00 GMT

below script will help you. To achieve field value.

Load *,

left(State,1)&1 as Store,

Qty*0.8 as QtyNew

Resident Data;

Load *,

left(State,1)&2 as Store,

Qty*0.2 as QtyNew

Resident Data;

It will autoconcate your data.

Re: Caluclate 80-20% in backend

kusumanchir — Thu, 03 Aug 2017 09:20:21 GMT

Hi Gourav,

I have modified such a way , single columns holds the M1,M2,D1,D2...

Re: Caluclate 80-20% in backend

bharani8 — Thu, 03 Aug 2017 09:46:44 GMT

Hi.. Check the attached file.. Is this what you were looking for?

Re: Caluclate 80-20% in backend

kusumanchir — Thu, 03 Aug 2017 10:07:22 GMT

Hi Gourav,

I simplified the expression used in the script. please refer to the latest attachment.

Re: Caluclate 80-20% in backend

bharani8 — Thu, 03 Aug 2017 10:11:04 GMT

In Qty Field we see only M2,H2,,,series.. Not M1..H1..

Re: Caluclate 80-20% in backend

kusumanchir — Thu, 03 Aug 2017 10:23:38 GMT

Hi Bharani,

Yes, the values of QTY field is coming in 20% bracket. So all the values are M2,D2...

Regards,

Rasly.K