Adjust below premium to above row and remove that row

[kartikaysingh]

@Hi,

I have a query which my customer have asked to manipulate for his better understanding.

In the above picture customer wants that BI/Rent Exp value should be adjusted or moved to one line above i.e. 96,000 should move above to replace 0 .

In short customer do not want the whole line of Index=NIL and rather want the values adjusted above for Index=B35.

Can anyone suggest how this can be achieved in Qlikview

[vishsaggi]

We cannot see the image, can you share some sample data and expected output?

[kartikaysingh]

Can you see it now, I have reposted.

[ogautier62]

Hi,

add a dimension as :

if( index='NIL','B35',index)

and use sum() for your amount expression

regards

[vishsaggi]

Is NIL a value coming from excel or is that going to be a Null value? Do you have this sample data file so that we can work on? May be you can try like

= IF(Above(BI/RentExposure,0,4) = 0, Below(BI/RentExposure),0)

Can you also show the expr used for BI/RentExposure?

[kartikaysingh]

Hi Olivier,

B35 is just one of the Index examples that I tried to show here.

Report have many scenarios where we have Indexes different than B35 for e.g. like N31 and NIL. So how to tackle that?

[ogautier62]

so I don't see if it depends on multiple codes,

another way : cumulate for all index, so 1 ligne for all scenarios

but you can't see the code

[kartikaysingh]

Hi Vishwarath,

NIL is a value coming from an Oracle table.

BI/Rent Exposure is a straight away a premium field coming from the sample table.

[kartikaysingh]

I guess I done think it will accumulate as Indexes are different

[vishsaggi]

Can you share some sample data in an excel to look into?