topic Re: Pivot Chart sub total value details in QlikView

Pivot Chart sub total value details

Fri, 21 Oct 2011 05:01:24 GMT

In Pivot chart, I have dimension (location,item) , expressions(quantity,value). Here, I have value but quantity is zero for some items. I need to cut this value when quantity is zero. after that sub total(show partial columns - by checked) is having the total value(including value of zero quantity). So please give me suggestions.

my expression for Qunatity is == sum(PQTY-MQTY)

my expression for Value is == sum(PSTOCKVALUE-MSTOCKVALUE)

Expecting your reply.

Thanks

Kumar

Pivot Chart sub total value details

Fri, 21 Oct 2011 05:06:24 GMT

Hi ,

Could you plese post your file with some sample data..

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 05:06:36 GMT

Hi ,

Could you plese post your file with some sample data..

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 05:15:02 GMT

Location Item Qty Value

Stores Apple 5 10

orange 12 15

banana 0 3

grapes 0 2

pineapple 2 6

total 19 36

i need

total 19 31

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 05:20:44 GMT

is the data ok.. or should i attach file??

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 05:25:02 GMT

It would be fine if you could attach the File also..

Thanks

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 06:39:11 GMT

hi pls give me suggestions

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 06:46:26 GMT

Hi,

You have already done with the table where you were not showing the zero values.. May I know what is the requirement that is pending..

Thanks

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 06:46:36 GMT

Hi,

You have already done with the table where you were not showing the zero values.. May I know what is the requirement that is pending..

Thanks

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 06:48:33 GMT

in this item ID total is not equal to sum of rows displayed. that is my exact problem.

Re: Pivot Chart sub total value details

rohit214 — Fri, 21 Oct 2011 06:55:29 GMT

try this

in Script:

if(Qty=0 0r isnull(Qty='-1'),'0','1') as Flag

in expression:

sum(Qty*Flag)

Sum(Value*Flag)

may it hepls you

thanks

rohit

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 07:18:02 GMT

flag expression is giving error

pls chk.

rgds

kumar

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 07:20:31 GMT

Hi,

try this..

if(Qty=0 0r isnull(Qty),'0','1') as Flag

Hope that is fine...

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 07:20:39 GMT

Hi,

try this..

if(Qty=0 0r isnull(Qty),'0','1') as Flag

Hope that is fine...

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 07:25:49 GMT

while reloading it is showing error.

kumar

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 07:29:59 GMT

The expression is correct only .. unless u have the Qty field in the table it will throw an error..

* if(Qty=0 0r isnull(Qty='-1'),'0','1') as Flag

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 07:37:07 GMT

while reloading expr is giving error

kumar

Re: Pivot Chart sub total value details

Fri, 21 Oct 2011 08:42:49 GMT

pls give me sugesstions

kumar