5 Replies Latest reply: Dec 11, 2017 1:41 AM by Avinash R RSS

    [ASK]Hierarchy-How to fill empty fields with the latest n-level fields?

    Rendi Yanuar

      Dear QlikView,

       

      I have generate data with hierarchy function and result like below :

      Untitled.png

       

      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 :

      Untitled.png

       

      And my question is,

      is that result achieveable with QLikView load script?

      if it is yes, please help me with some guide.

       

      Many Thanks