Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

capriconuser
New Contributor III

logic

I have this type of data

HEAD                            TYPE                   EXP_TYPE         CODES            

ADSPNGE751-71510%  to IE
ADSPNAE751-71610% IE

above tables shows that 10 % goes to IE and other goes to GE 

and in second row 10% go to IE and other 90% go to AE i.e. we must total to 100% not above 100

now here in below that how i distributed % according to above table to make 100% because above table shows that 90% to AE 90% TO GE and 10 % to IE  this because around 190 but i want to make this 100 how i do this or is there any formula we apply to make total 100 %

AND THIS ANOTHER SHEET

     

headLEAEGETEIE
ADS909010
Tags (2)
2 Replies
YoussefBelloum
Esteemed Contributor

Re: logic

Hi,

how do you calculate the % ? do you calculate it on the script or on the chart ?

capriconuser
New Contributor III

Re: logic

% here is given by customer.. and not necessary this is 10% this is may 20% to IE and remaining % to GE

Community Browser