Hello,
Is it possible to generate field names within the Qlikview script?
Currently, I have 2 fields: Store and Detail.
What I would like to do is generate more detail fields based on if a store has multiple "Detail" rows
For example, I'd like a generate something like this:
| Store | Detail | Detail2 | Detail3 | Detail4 |
|---|
| StoreA | Detail1 | Detail2 | Detail3 | Detail4 |
| StoreA | Detail2 | - | - | - |
| StoreA | Detail3 | - | - | - |
| StoreA | Detail4 | - | - | - |
| StoreB | Detail1 | - | - | - |
| StoreC | Detail1 | - | - | - |
| StoreC | Detail1 | Detail2 | - | - |
| StoreC | Detail2 | - | - | - |
Is this possible?
Thank you in advance
