This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a requirement where my values are in pivot table
date April 1 May 1
Type count value total count value total whole total
Type 1 3 5 15(3*5) 3 4 12 15+12=27
Product Type 2 4 6 24 4 7 28 24+28=52
Please suggest me how to caliculate that whole total value in my pivot table..
This might help:
No it is giving full total..by row wise.
and we have also several expressions in expressions tab.
That whole total value should came(pick) from each date wise.
I think you must calculate each values with set analysis per month and on the last the cumul with the function column.
you can automatise the value of the month also.