Discussion Board for collaboration related to Creating Analytics for QlikView.
I have generate data with hierarchy function and result like below :
As we now, with hierarchy function qlikview will generate all level that possible.
But will leave blank to the field that certain row that not use that field.
In other side, my client expectation the result will be like below :
And my question is,
is that result achieveable with QLikView load script?
if it is yes, please help me with some guide.
Can you try something like this?
If([Node Name2]=FindOneOf([Node Name2], '0123456789'), Previous([Node Name1]) as [Node Name2]
what does it mean?
i've tried it and nothing happen.
My intention is this?
LOAD RowNo() as ID,
LOAD ID, [Node Name1], If(FindOneOf([Node Name2], '0123456789'), [Node Name1],[Node Name2]) as [Node Name2]
DROP Table Sample;
Same Way, You can use for next 2 nodes ..
Will this issue resolved? I know this is long time. But, you have to understand how Qlik community works for helpers. If it is, Please close this thread ..
try like this
if (len( trim( [Node Name2]))=0, Peek([Node Name1]),[Node Name2]) as [Node Name2]
similiar you could apply for other columns too