topic Product Description in QlikView

Product Description

Thu, 21 Jan 2010 17:38:14 GMT

Hi,

I have a table called product_dim where I have to eliminate the product_descripyion starting with GIFT or Gift.So, I have used the where clause in the load statement of product_dim as below:

where left(PRODUCT_DESCRIPTION,4)<>'GIFT' and left(PRODUCT_DESCRIPTION,4)<>'Gift'

I have to calculate the sum of sales of all the product except the above mention.I have Pivot table where it shows for product description starting with GIFT or Gift as '-' in the product_description column but shows values in sales column.

My requirement is that it should not show the corresponding sales amount also.

Pls help me in thie case.

Thanks,

Swetha

Product Description

Thu, 21 Jan 2010 18:17:43 GMT

Hi, you can click on the properties of your char and go to dimensions tab, then you can select the option "supress when value is null". That should do the work.

Regards

Product Description

Thu, 21 Jan 2010 18:22:39 GMT

Thank You for the reply.I tried it but not working.

Product Description

Thu, 21 Jan 2010 18:28:40 GMT

Hi,

Its not showing the product_description but on sales its adding the amount assigned to this product description.So even if I check this option or not my sum of sales is shown as same.

Thanks,

Swetha