Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation ABC

Hello, everyone.

I have the table:

Data:

LOAD * Inline [

PERIOD_ID,        REGION,        DRUGS_ID,    V_UAH,     Q,        COMPANY

201601001,        103,        1001,        50,        1,        111

201601001,        103,        1002,        75,        1,        111

201601001,        103,        1003,        265,    1,        111

201601001,        104,        1001,        55,        1,        111

201601001,        104,        1002,        75,        1,        111

201601001,        105,        1001,        51,        1,        111

201601001,        105,        1002,        80,        1,        111

201601001,        105,        1003,        400,    1,        111

201601001,        105,        1004,        8,        1,        111

201601001,        105,        1005,        560,    1,        111

201601002,        103,        1001,        45,        1,        111

201601002,        103,        1002,        77,        1,        111

201601002,        103,        1010,        430,    1,        111

201601002,        103,        1011,        60,        1,        111

201601002,        104,        1001,        54,        1,        111

201601002,        104,        1002,        74,        1,        111

201601002,        104,        1013,        98,        1,        111

201601002,        105,        1001,        64,        1,        111

201601002,        105,        1014,        120,    1,        111

201601002,        105,        1015,        32,        1,        111

201601001,        103,        1001,        60,        1,        222

201601001,        103,        1002,        73,        1,        222

201601001,        103,        1003,        295,    1,        222

201601001,        104,        1001,        56,        1,        222

201601001,        104,        1002,        70,        1,        222

201601001,        105,        1001,        54,        1,        222

201601001,        105,        1002,        84,        1,        222

201601001,        105,        1003,        460,    1,        222

201601001,        105,        1004,        9,        1,        222

201601001,        105,        1005,        600,    1,        222

201601002,        103,        1001,        49,        1,        222

201601002,        103,        1002,        71,        1,        222

201601002,        103,        1010,        530,    1,        222

201601002,        103,        1011,        67,        1,        222

201601002,        104,        1001,        57,        1,        222

201601002,        104,        1002,        77,        1,        222

201601002,        104,        1013,        97,        1,        222

201601002,        105,        1001,        67,        1,        222

201601002,        105,        1014,        122,    1,        222

201601002,        105,        1015,        37,        1,        222

];

I need to calculate ABC in chart:

How do it?

P. s. I am sorry for my english.

10 Replies
Not applicable
Author

Hello, everyone.

This question is solved.

Thanks a lot everyony, thanks Sunny T, kushal chawda, Marcus Sommer !!!

Have a nice day.