topic Merging dimensions in QlikView

Merging dimensions

Mon, 27 Jul 2015 17:45:20 GMT

Hi,

I trying to combine 2 dimensions into one using Edit Dimension:

=If(CSTM_LocalChannel2Hist = 'A1', 'A1',
If(CSTM_LocalChannel2Hist = 'A2', 'A2',
If(CSTM_LocalChannel2Hist = 'A3', 'A2'
If(CSTM_LocalChannel2Hist = 'A4', 'A2
If(CSTM_LocalChannel1Hist = 'A5', 'A5'
If(CSTM_LocalChannel1Hist = 'A6', 'A6'
If(CSTM_LocalChannel1Hist = 'A7','A7'

')))))))

I have an expression:

=If(CSTM_LocalChannel2Hist = 'A1',Sum({$<ACCT_Account0={'Net - Sales'}>}GNLD_AmountLCY),
If(CSTM_LocalChannel2Hist = 'A2',Sum({$<ACCT_Account0={'Net - Sales'}>}GNLD_AmountLCY),
If(CSTM_LocalChannel1Hist = 'A3',Sum({$<ACCT_Account0={'Net - Sales'}>}GNLD_AmountLCY),
If(CSTM_LocalChannel1Hist = 'A4'',Sum({$<ACCT_Account0={'Net - Sales'}>}GNLD_AmountLCY),
If(CSTM_LocalChannel1Hist = 'A5',Sum({$<ACCT_Account0={'Net - Sales'}>}GNLD_AmountLCY))))))

This only works when A2 has values and A3 and A4 does not.

I'm a bit stuck:-)

Thomas

Re: Merging dimensions

robert_mika — Mon, 27 Jul 2015 19:21:39 GMT

In the expression part all the set analysis are the same.

Is the any reason for that?

Can you post your data,desired outcome or screenshot.

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Merging dimensions

Mon, 27 Jul 2015 19:27:07 GMT

I basically just need the 'Net - Sales' for the A1....A5 dimension values. There are many more in the dimension.

A3 and A4 need to be shown with A2 in one line as A2. So the sum of the 3.

Re: Merging dimensions

robert_mika — Mon, 27 Jul 2015 19:34:47 GMT

Could you post your data?

Re: Merging dimensions

Mon, 27 Jul 2015 21:36:27 GMT

I have 2 dimensions:

CSTM_LocalChannel1Hist

CSTM_LocalChannel2Hist

I need some entries from one of them and some entries from the other, so I get chart/table with:

A1 and GNLD_AmountLCY

A2 and GNLD_AmountLCY

A3 and GNLD_AmountLCY

A4 and GNLD_AmountLCY

A5 and GNLD_AmountLCY