topic Issue with parital sums in QlikView

Issue with parital sums

Wed, 22 Dec 2010 08:50:21 GMT

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;

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.

Issue with parital sums

Wed, 22 Dec 2010 10:01:33 GMT

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??

Issue with parital sums

Wed, 22 Dec 2010 10:13:57 GMT

Hi,

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

Issue with parital sums

sunil2288 — Wed, 22 Dec 2010 11:00:31 GMT

Hi MSa,

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

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

Issue with parital sums

Wed, 22 Dec 2010 11:26:19 GMT

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

Issue with parital sums

Wed, 22 Dec 2010 11:34:05 GMT

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,

Issue with parital sums

Wed, 22 Dec 2010 11:56:12 GMT

Something like this??