Master Measure not shown in a specific row in a table

AndreH — Tue, 19 Sep 2023 06:50:26 GMT

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é

Re: Master Measure not shown in a specific row in a table

AndreH — Wed, 20 Sep 2023 09:10:29 GMT

Additional: If I store the Formel in a variable it works... don't know why

topic Master Measure not shown in a specific row in a table in App Development

Master Measure not shown in a specific row in a table

Re: Master Measure not shown in a specific row in a table