Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Compare Own Company Sales with Other Company

Hi all,

I have following data set like  Company , Product , Customer and his area  , my requirement is when user will see 2 charts

own company sale vs Other Company Sale with Area will be common between this 2 charts

 

CompanyProductSalesMonthYearCustomerArea
AMS25000201804C1Mumbai
AHS35000201804C1Mumbai
BMS55000201804C2Thane
BHS65000201804C2Thane
CMS24000201804C3Raigad
CHS35000201804C3Raigad
AMS24800201805C1Mumbai
AHS34800201805C1Mumbai
BMS54800201805C2Thane
BHS64800201805C2Thane
CMS23800201805C3Raigad
CHS34800201805C3Raigad

Requirement is like this :

   

Period  : 201804
Own Company Sales Analysis
CompanyProductAreaSale
AMSMumbai25000
AHSThane35000
Other Company Sales Analysis
CompanyProductAreaSale
BMSMumbai55000
BHSThane65000
CMSMumbai24000
CHSThane35000

  How to achieve the same in Qlik sense ?

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
4 Replies
ogautier62
Specialist II
Specialist II

Hi,

use as first dimension :

if(Company = 'A','Own','Others')

then Company, Product, Area

in expression :

sum({< Area = P({<Company = {'A'} >}) >} sales)

regards

brunobertels
Master
Master

Hi

Create 2 Tables

1er table:

Dimension

company

product

area

Mesure : Sum(Sales)

and 2nd table:

Dimension

company

product

area

MEsure :

Sum({1-$}Sales)

ex :Capture.PNG

vikasmahajan
Author

Thanks all for your answers But i have ended with following expression.

Count({< Company=E({<Company={'A'}>}) ,Area = p(Area)  ,Customer=>} Company)

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
ogautier62
Specialist II
Specialist II

hi,

are you sure you'll have common area with area= p (area) ?