Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kartikaysingh
Contributor III
Contributor III

Adjust below premium to above row and remove that row

@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

18 Replies
vishsaggi
Champion III
Champion III

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

kartikaysingh
Contributor III
Contributor III
Author

Can you see it now, I have reposted.

ogautier62
Specialist II
Specialist II

Hi,

add a dimension as :

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

and use sum() for your amount expression

regards

vishsaggi
Champion III
Champion III

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
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

vishsaggi
Champion III
Champion III

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