Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hello moorthi
Go through the fallowing manual contains full explanation how to handle NULL values
Thanks
sasi@