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

[ogautier62]

if you supress index as expression,

and replace by concatenate(index,'/')

you'll have  B35/NIL for example

[ogautier62]

may an awfull solution which could work :

as new dimension

if(BI/RentExp <> 0,index, aggr(MinString({<Index = {"=BI/RentExp = 0" >} index), you upper dimension or ID) )

ie : if BI/Rent <> 0 ligne is displayed,

                    = 0  it's cumulate with another line

best choice should be to do it in script

[kartikaysingh]

So are you saying that I should take Item Index in expression and then disable it and then replace it with concatenate(Item Index,'/')?

[kartikaysingh]

I did try this but for many columns I am getting - or blanks.

[ogautier62]

yes because you have a new dimension

expression must have an agregation function

are first text columns all same value for different index ?

if yes : you can use maxstring(your text column)

if no : in script, no choice

[kartikaysingh]

I did try giving each dimension as maxstring(dimension) which did not worked. Will try it in script.

Thanks for your answers.

[Anil_Babu_Samineni]

I Would like to test your application. Can we expect sample?

[kartikaysingh]

I have attached the excel in the thread

[kartikaysingh]

I have attached a sample excel.