Discussion Board for collaboration on QlikView Scripting.
my question is pretty much summed up in the title:
=> I have a table in which there is one field I need to both
- duplicate (with yet another name)
The background is that this field is a keyfield, but I need a duplicate of it that won't be linked so I can properly count it - which doesn't work with keyfields.
Is there any way I can do that without RESIDENT LOADing the entire table?
Thanks a lot!
Go to Solution.
In the same table you can the fields twice rite?
Key as Count_key,
Key as Test
Perhaps I don't understand your question, but I'm thinking:
autonumber(Key) as CountKey,
Or perhaps even simpler:
1 as Counter,
you can define the field twice and give it a different name.
sample as Key,
sample as Key2