Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with parital sums

Dear All,

I'm using a pivot table in which i have divided the results of my expressions into three parts by dimensions as follows;

error loading image

Through dimensionality, i've managed to remove the unit price totals. I need all other totals apart from those circled in green.

Is there a way by which i can remove the totals circled in green but keep those circled in red.

Also is there any other way to calculate a total apart from clicking the partial sums checkbox in the presentation tab.

thanks.

1 Solution

Accepted Solutions
Not applicable
Author

Something like this??

View solution in original post

6 Replies
Not applicable
Author

Why you want totals for januari? and not the other months? If so, use the same dimensionality() function with an IF (month='jan') statement for month??

Not applicable
Author

Hi,

Thanks for your reply, im not sure i get what you mean though?

sunil2288
Creator III
Creator III

Hi MSa,

If you does want the total of Only for the month of january Then you should put condition in the expression

As

{<$(Month)-={'January',.....)>}

Not applicable
Author

can you send me the qvw, so i can have a look

Not applicable
Author

Hi,

I couldn't attach the qvw so i posted it here;

http://community.qlik.com/members/msadrikhcb/files/sample.qvw.aspx

Hi Sunil, thanks for your reply but that does not give me exactly what i want.

regards,

Not applicable
Author

Something like this??