Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nayanqlik
New Contributor III

How to combine different dimension in an object

Hi

For simplicity, I have the 2 tables below in my front end (Table1 & Table 2).  The one is Sales by Manager whereas the other is Survey Count by Survey Manager.  The values in the Manager and Sales Manager fields are the same person. I want to create a table in the front end where Manager and Survey Manager are linked. (see below table Correct).

However, my table is not displaying correct (see table marked Incorrect)


Please note, I don't want to link it in the backend as it has implications on other parts of the model.

So, can this be solved in the frontend only.


Your assistance is appreciated.

Kind regards

Nayan

Table 1

ManagerSales
A20
B30
C60

  Table 2

Survey ManagerSurvey Count
A6
B10
C15

Correct

Sales ManagerSales Manager SurveySalesSurvey Count
AA206
BB3010
CC6015

Incorrect

Sales ManagerSales Manager SurveySalesSurvey Count
AA206
AB2010
AC2015
BA306
BB3010
BC3015
CA606
CB6010
CC6015
1 Solution

Accepted Solutions

Re: How to combine different dimension in an object

Check the attached

Capture.PNG

8 Replies

Re: How to combine different dimension in an object

May be just do this

If([Manager] = [Survey Manager], Sum(Sales))

If([Manager] = [Survey Manager], Sum([Survey Count]))

nayanqlik
New Contributor III

Re: How to combine different dimension in an object

Hi Sunny

Thank you for your quick response.  I will try and let you know.

Kind regards

Nayan

Re: How to combine different dimension in an object

Check the attached

Capture.PNG

Digvijay_Singh
Honored Contributor III

Re: How to combine different dimension in an object

May be try like this -

Capture.PNG

nayanqlik
New Contributor III

Re: How to combine different dimension in an object

Hi Sunny

It worked.  Another twist.  I have a lower level dimension.  Employee which falls under Manager and Survey Employee falling under Survey Manager.

So will the formula be

If([Manager] = [Survey Manager] or [Employee] = [Survey Employee], Sum(Sales))

If([Manager] = [Survey Manager] or [Employee] = [Survey Employee],, Sum([Survey Count]))



Kind regards

Nayan

Re: How to combine different dimension in an object

May be using and instead of or....

qv_testing
Valued Contributor

Re: How to combine different dimension in an object

HI,

why don't you make associate 2 tables with Manager.

Like

Table1:

LOAD * INLINE [

    Manager, Sales

    A, 20

    B, 30

    C, 60

];


Table2:

LOAD *,  [Survey Manager] as Manager;

LOAD * INLINE [

    Survey Manager, Survey Count

    A, 6

    B, 10

    C, 15

];

Then you can use simple expression.

Sum(Sales)

sum(Survey Count)

nayanqlik
New Contributor III

Re: How to combine different dimension in an object

Hi Digvijay

Your formula worked too.  See my response to Sunny, regarding a lower level of staff. I have an  Employee which falls under Manager and Survey Employee falling under Survey Manager.


Should i apply similar formula to the one you have given for manager.


Kind regards

Nayan

Community Browser