topic Re: divide column values not working in straight table? please help in QlikView

divide column values not working in straight table? please help

Fri, 07 Aug 2015 11:17:22 GMT

Hi,

when I am dividing column values in straight table it is showing blanks

I have below data in straight table

ID	name	source	months	date	sales	divide
52524546	xx	goods	60	14/04/2015	35634	-

dimensions: ID,name,source

expressions: months,date,sales,divide

I need divide column as calculated one as below

so, I have used divide = Column(3)/Column(1). this is not working.

how to get this correctly?

Thanks.

sebastianlettner — Fri, 07 Aug 2015 11:24:00 GMT

Hi,

as far as I know this should work like you described.

Can you upload an example .qvw?

Digvijay_Singh — Fri, 07 Aug 2015 11:34:16 GMT

See attached, but not sure the business case as aggregation logic cannot be understand from one row.

sujeetsingh — Fri, 07 Aug 2015 11:35:18 GMT

Try using expressions

krishna20 — Fri, 07 Aug 2015 11:44:00 GMT

Hi,

Check whether the column no's are given correctly or not.

-> Try with Expression Label names to achieve division.

-> Try using direct expressions.

Fri, 07 Aug 2015 11:55:17 GMT

Thanks. I tried this. not working. I have used in script as below

sales/months

this worked.

sasiparupudi1 — Fri, 07 Aug 2015 13:02:58 GMT

may be you have a divide/0 issue? try if (column(1)>0,column(3)/Column(1),0)