topic Showing Null Value in QlikView

Showing Null Value

Thu, 12 Apr 2012 13:05:40 GMT

I have a straight table in which i have used Product list and Date as dimension. Product list has 5 Products out of which i have listed 4 products in the table. so i have given Calculated dimension as

Product List<>5

In expression i have written first expression has

sum

(Volume)

in second expression i have written

aggr

(sum({$<%PID={5}>} Volume),Date)

From the first expression i am getting Sum(Volume) for all the products in one column. but from the second expression i am getting volume of the 5th product but that is coming only in 1st row of the second column all the other rows are showing null values. I want to list the volume of 5th product in all the rows.

How it can be done ??

Showing Null Value

CELAMBARASAN — Thu, 12 Apr 2012 13:10:05 GMT

Hi,

try with this

$(=aggr(sum({$<%PID={5}>} Volume),Date)))

Celambarasan

Re: Showing Null Value

Thu, 12 Apr 2012 13:15:21 GMT

Hi Celambarasan,

$(=aggr(sum({$<%PID={5}>} TRx_Volume),Date))

I tried this. But its not working. Now all the values are comin Null

Showing Null Value

jagan — Thu, 12 Apr 2012 13:20:21 GMT

Hi,

Assign this to a variable

vTest = Sum(aggr(sum({$<[%PID]={5}>} TRx_Volume),Date))

Now use this variable in the expression as

=vTest

Now it displays all the cells with calculated value.

Hope this helps you.

Regards,

Jagan.

Re: Showing Null Value

Thu, 12 Apr 2012 13:22:30 GMT

i can not do that because for different dates different values are there but variable will store only one particular value at a time.

Showing Null Value

Thu, 12 Apr 2012 13:35:21 GMT

The final table should look like this

Date Product sum(volume) sum for product 5

1 1 5.11 10

1 2 5.40 10

1 3 30.5 10

1 4 10.78 10

2 1 19.67 20

2 2 52.4 20

2 3 30.45 20

2 4 10.45 20

Re: Showing Null Value

CELAMBARASAN — Thu, 12 Apr 2012 13:36:04 GMT

Hi,

Check with this

$(=Sum(aggr(sum({$<%PID={5}>} Volume),Date))))

Celambarasan

Re: Showing Null Value

Thu, 12 Apr 2012 13:40:18 GMT

Hi Celambaran,

$(=Sum(aggr(sum({$<%PID={5}>} Volume),Date)))

This expression is giving value 0 in every row.

Re: Showing Null Value

CELAMBARASAN — Thu, 12 Apr 2012 13:40:46 GMT

Hi,

Try with total keyword

Sum(TOTAL <Date>{$<%PID={5}>} Volume)

Use this Expression without using calculated dimension

Celambarasan

Re: Showing Null Value

Thu, 12 Apr 2012 17:39:52 GMT

Thanks Celambarasan. It works I was struggling to get this correct since last 3 days. Thanks a lot