
Partial Sums Queries
sergio . Dec 12, 2010 12:34 PM (in response to msadrikhcb)Hi msadrirkhcb,
Your first problem I think it´s easy to solve. Just go presentation tab in pivot table properties and you will control subtotals by marking or unmarking partial sums option (by each dimension).
The second one I think it has no solution because it´s qlikview standard functionality. Depending on what you are trying to do, you must create another figure to solve your problem. In my work, I use a lot of pivot tables but that functionality isn´t a problem for me; if I don´t want to lose some data, I use a text box to do some calculations.
However, if you look at the finance controlling example on your qlikview, you can collect some ideas.
I hope It hepls you.
Fiber

Partial Sums Queries
msadrikhcb Dec 13, 2010 1:11 AM (in response to sergio .)Hi Fiber,
Thanks for your answer, but it's not what i was looking for. The subtotals come under the expressions so i cannot uncheck them and besides i need one out of the three, in presentation tab all of them are either checked together or not at all.
With regard to the second, i will try to use a seperate text box.
Regards,

Partial Sums Queries
Kaushal Mehta Dec 13, 2010 1:49 AM (in response to msadrikhcb)Hi msadrikcb,
First Solution,
Calculate the sum of process on scripting part with if condition.
so u will get the one sub total insted of three sub total.



Partial Sums Queries
msadrikhcb Dec 29, 2010 4:11 AM (in response to msadrikhcb)Hi All,
Thanks for your answers and help, through trial and error and with the help of some other users, I have managed to find the following solution.
If(Dimensionality()>1, If(Product='A' OR Product='B' OR Product='C', If(trim([Month])='Jan', If(Product='A' OR Product='B' OR Product='C' )))
For the first problem we can implement dimensionality ans use the following;
This will solve the problem in pivot table to restrict partial sums.
For the second problem, we can use a text box or an input box thus creating a variable.
So instead of using Sum(Amount), we use Sum({$} Amount). This in a variable or a text box will display the Total amount yet when aselection is made the total will remain the same i.e. if we need to show 800 and we choose the product which is 200 units then the unit will be displayed as 200 but the total will return the 800.