Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Issue with parital sums

Something like this??

6 Replies
Not applicable

Issue with parital sums

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

Issue with parital sums

Hi,

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

sunil2288
Contributor III

Issue with parital sums

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

Issue with parital sums

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

Not applicable

Issue with parital sums

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

Issue with parital sums

Something like this??

Community Browser