Discussion Board for collaboration related to QlikView Deployment.
I have a table like:
Now I want one more record for all comp (A,B here) which is a calculated one (say Item ->Calc3) like
Calc3 = Item->1*2
So out put should be like:
Note: In real scenario, there would be many more items and comps
Load Item,Comp,Amount*2 as Amount
Thanks Kaushik for your reply. However,
sorry, i should have mentioned that it would be Item specific rather than all items. Say there are 100 items, and I want 101st item to be like that (Calc3 = Item ->1 *2)
i think there will be another field that it indicates last item, for example date...can you please mention that....
Kaushik's answer is OK.
Add a WHERE statement if the computation should be done on some items only.
No it's not about last item. It is simply about creating a new record which has a reference to another/more records. It may be like:
Item Comp Amt
1 A 1
1 B 2
2 A 3
2 B 4
Calc3 A (amt of item->1)*2 =2
Calc3 B (amt of item->1)*2 =4
Hope, it's bit clearer.
What are the items ? How do you catch them ?
Nope ! Let me rephrase it:
Create a new RECORD which is calculated against some other records:
4 // 4 is calculated like item1+item2
first 10 Load Item,Comp,Amount*2 as Amount