topic Re: Creating a new column in table with Div formula in QlikView

Creating a new column in table with Div formula

Anonymous — Mon, 19 Nov 2018 03:25:05 GMT

Hi All,

this is my first post in the Qlik community. I've recently started using QlikSense for work purpose. However, i cant seem to figure out how do i add 1 more column in the table with a formula. As shown below, i would require a new column that divides Total Sales by Quantity sold.

Total Sales (column 1) -------------Quantity (column 2) ----- Price per piece (column 3)

The Div function is not working as it should. Kindly advice.

Thanks!

Re: Creating a new column in table with Div formula

tresB — Mon, 19 Nov 2018 05:50:31 GMT

Are you trying to create this new column in the UI or script? Could you share a sample app explaining the expected output?

Re: Creating a new column in table with Div formula

Anonymous — Mon, 19 Nov 2018 06:00:39 GMT

Hi,

I'm trying to create it though UI. any suggestions?

R12 desired output should be 23.55

Thanks

Re: Creating a new column in table with Div formula

tresB — Mon, 19 Nov 2018 06:10:24 GMT

What are formulas you are using for all three columns?