Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

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

4 Replies
ogautier62
Valued Contributor II

Re: Compare Own Company Sales with Other Company

Hi,

use as first dimension :

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

then Company, Product, Area

in expression :

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

regards

brunobertels
Valued Contributor

Re: Compare Own Company Sales with Other Company

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
Honored Contributor III

Re: Compare Own Company Sales with Other Company

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

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

Vikas

ogautier62
Valued Contributor II

Re: Compare Own Company Sales with Other Company

hi,

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