Discussion Board for collaboration related to QlikView App Development.
I have two dimensions, Vintage and DLQT_STAT: And have an expression as Sum(Sales).
Now I have to create a new table.
Unable to explain the logic, I have created a excel with formula.
Table2 has same dimensions just need to change the expression. Any idea how I can achieve it?
Hope, you are using pivot table. Then try this expression
Format should be, Fixed 2, percentage.
View solution in original post
Would you be able to share a qvw sample to play around with?
Try using this:
Sum(Sales) / Sum(TOTAL Sales)
Also do not forget in Presentation tab to change numeric format:
Read more about TOTAL in expression and it's use in here:
The Aggregation Scope
What does the TOTAL qualifier do?
Sure Sunny, adding the sample in a new thread.
Hi Mindaugas, Its not that simple.