topic Re: Expression Help in QlikView

Expression Help

Thu, 12 Dec 2013 11:55:17 GMT

Hi,

I doing what if analysis in straight table.

Need calculation for What - if Revenue = (What - if Price)*(What-if Sold).

For ref. please find the attached qvw.

Thanks in advance.

giakoum — Thu, 12 Dec 2013 11:58:15 GMT

What is the problem using =column(4)*column(5)?

Thu, 12 Dec 2013 12:15:28 GMT

Hi,

If I multiply - Column (4)*Column(5) = Value is wrong.

for example = 205*39 = 7995, But in Straight Table it is 7893.

giakoum — Thu, 12 Dec 2013 12:19:10 GMT

yes because you are rounding up. If you change all number formats to fixed to with 2 decimals it will be exactly.

Thu, 12 Dec 2013 12:21:52 GMT

It is not coming in my Straight Table, Can you please correct in QVW and revert to me.

Thanks

giakoum — Thu, 12 Dec 2013 12:29:48 GMT

Properties --> Number tab to set number format

maxgro — Thu, 12 Dec 2013 12:45:10 GMT

try this

(Sum(Seats) * (1+ $(vQty)/100)) * (([Booking Fees]) + $(vValue))