Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi together,
I'm confused and I hope anyone could help me.
For a specfic pnl - table I've created a dimension table.
dimension_tbl:
Load * INLINE [
RowsRollingPeriod,
"absolut",
"-.-",
"change abs.",
"change %",
"concentration",
"-..-",
"avg. change abs.",
"max. change abs.",
"min. change abs.",
"-...-",
"avg. change %",
"max. change %",
"min. change %",
];
For all these rows I'm calculation the measures via master measure for specific time periods. All these master measures
are working correct. I can use them for KPI fields e.g.
To allocate the master measures to my "own" dimensions I'm working with PICK & MATCH.
Example:
=PICK (MATCH(RowsRollingPeriod, 'absolut',
'-.-',
'change abs.',
'change %',
'concentration',
'-..-',
'avg. change abs.',
'max. change abs.',
'min. change abs.',
'-...-',
'avg. change %',
'max. change %',
'min. change %'
),
//absolut
sum_bal_local_PreviousDay,
//-.-
'',
//change abs.
delta_currPrev_day,
//change %
num(delta_perc_currPrev_day, '#.##0,00%'),
//concentration
num(concen_PrevDay, '#.##0,00%'),
//-..-
'',
//average change abs.
avg_balance_prev_day,
// max change abs
//0,
max_balance_current_prev_day,
// min. change abs
0,
//-...-
'',
//avg. change %
0,
// max change %
0,
// min. change %
0
)
All this is working great. But when I'm going to add an master measure which is working with MAX/AVG/MIN in combination with AGGR this measure can only be shown in the first row.
E.G. Master Measure with identifies the max change betwenn two days in a specific time period
MAX (AGGR (
Above ( Sum ( {$ <TYPE={'BALANCES'} , BOOKING_DATE = {">=$(vPreviousDate) "} >} LCY_AMT )) -
Sum ( {$ <TYPE={'BALANCES'} , BOOKING_DATE = {">=$(vPreviousDate) "} >} LCY_AMT)
, BOOKING_DATE)
)
Putting this measure in the first line of my PICK | MATCH field it works.
Trying to bring this in the correct position ("max abs. change") the field won't be shown.
Anyone an idea why QlikSense is not working as I expect?
Thanks for your help
André
Additional: If I store the Formel in a variable it works... don't know why