Handling NULL Values

[#1]

Hi friend,

Im facing a problem that im having the Excel sheet, which having NULL value also. and i want to replace he null value into previous value (last non empty) value (LIKE prevmember in tableu/SSAS) .

i tried a expression

alt(max(amount),above(max(amount),1))

it failed if i select the particular date / field , and it display only to the next null value if 2 or more field is null then it is not through this result

Please help in this issue

For your reference i attach the excel and my Qlikview also.

[qlikpahadi07]

Hi Sundar,

well in your case i don't think it's easy to achieve from Front end like your case

"Take field aa(field)  =  AAAA and  bb(Field) = 1111"

if i am not wrong this will also go for other fields too ...

as per my Experience its possible through Back end or you can create a Master Table with all Items Listed from Day 1

and make right/ Outer join with you Fact Table.

Once we have a Dimensions with every Date then those Above Functions can easily work as you see you can create a Record with Loops in Backend only;  Front end is for display with few tricks but if Records are not there in your applications how can you display that in Front end.

I can suggest to work some in Back end (Script) not matter the data is in TB you can try optimized that .

Or wait for any other to reply

[sasikanth]

Hello moorthi

Go through the fallowing manual contains full explanation how to handle NULL values

Thanks

sasi@