This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have here an example of table I need to load in my application. Please see attached file.
Any advice you can give? Thank you.
Note: This excel file is loaded monthly and changes value for IDs assigned per level.
If you can create this file in a different way, it would be a lot easier. In the attachment, you can find two ways of defining hierarchies that you can use in QlikView.
The Expanded Nodes you can load as it is. The Adjacent Nodes you can load using the Hierarchy prefix.
^bump! need help on how to format it that way... without doing it manually...either by macro or scripting..
OK. Try this with your data:
LOAD ID, LVL1, LVL2,
If(Len(Trim(LVL3))>0, LVL3, If(LVL2=Peek(LVL2), Peek(LVL3))) as LVL3,
LOAD ID, LVL1,
If(Len(Trim(LVL2))>0, LVL2, If(LVL1=Peek(LVL1), Peek(LVL2))) as LVL2,
RecNo() as ID,
If(Len(Trim(LVL1))=0, Peek(LVL1), LVL1) as LVL1,
LVL2, LVL3, LVL4
FROM [Testhier.xlsx] (ooxml, embedded labels, table is Sheet1);