Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlikview and i'm stuck here
my problem is:
here product and Time are dimension and A,B,C etc are the values under Product field.
here i want one new row at the end, named "Total" that contains Sum of C,D,E only.
Load this as a Cross Table in your data model and you can play around with the tables
hi ravi there is option in Presentation tab..
use Totals Option
Create a new field in the script
ReportProduct:
load * inline [
ReportProduct, Product
A, A
B, B
C, C
D, D
E, E
F, F
Total, C
Total, D
Total, E
];
The use ReportProduct as dimension in your chart instead of Product. You'll see a new value Total that will show the summed values of C, D and E.
Hi,
Add below script in your expression,
If(Dimensionality()=0, Sum({<Product={"C","D","E"}>} Value), Sum (Value))
Check Show Partial Sum on Product in Presentation tab
Thanks
Please Chek it.
Use the Show Partial sums of some fields...