This content has been marked as final. Show 4 replies
I'm new to Qlikview application development and I need some help on writing an expression.
I was trying to add a second expression where it calculates the % of each cost category as of Premium (Please see the example table below). But I can only get a 100% for the premium line, which is correct, but 0 for the costs. I'm not farmilar with the set analysis so I guess something got messed up there....
Can someone help me with this? Your help is highly appreciated.
|NET_AMOUNT||% as of Premium|
|1 (represent Premium)||$100||100%|
|2 (represent Cost1)||$30||- (should be 30%)|
|3 (represent Cost2)||$40||- (should be 40%)|