Set analysis issue with island dimension

fabrice_lattern — Wed, 03 Jul 2019 11:30:53 GMT

Hello !

I am facing an issue with some requirement.

I have to build a stacked bar chart that present some YTD figures + the figures of the selected period, following a split by a dimension (called "sourcing group"). So I created an island table like this :

ANALYSIS: LOAD * INLINE [ ANALYSIS YTD PERIOD ];

and a dummy table with some data to reproduce the issue:

TEST: LOAD * INLINE [ PO NUMBER, MONTH, SOURCING GROUP, AMOUNT 1, 1, A, 100 2, 1, B, 200 3, 2, A, 80 4, 2, B, 20 5, 3, A, 90 ];

In my bar chart, I added the two dimensions ANALYSIS and SOURCING GROUP, and the following formula as an expression:

=if(ANALYSIS = 'YTD', SUM({<MONTH=>}AMOUNT), if(ANALYSIS='PERIOD', SUM(AMOUNT)))

The idea is to have:
- One column with the YTD figures, not depending on month selection
- One other column with the selected period figures

The issue is that on March, I have no data for sourcing group "B", and the YTD figures show only dimension "A" instead of showing the split.

I suppose that I have to use a calculated dimension, but I do not the expression to use.

Thanks in advance for any advice !

Re: Set analysis issue with island dimension

fabrice_lattern — Wed, 03 Jul 2019 12:10:25 GMT

I solved it using the following formula in the expression :

SUM({<MONTH=>}if(ANALYSIS = 'YTD', AMOUNT))+ SUM(if(ANALYSIS = 'PERIOD', AMOUNT))

topic Re: Set analysis issue with island dimension in QlikView

Set analysis issue with island dimension

Re: Set analysis issue with island dimension