topic Re: Create New Column in QlikView

Create New Column

Thu, 09 May 2013 10:42:33 GMT

Good morning,

I need to create a coulmn that is the total of another column, but I'm checking using TOP function and I always have only the firs row of the column.

I sent one example of my problem, maybe somebody could help me.

Thanks in advance

Re: Create New Column

Thu, 09 May 2013 10:48:16 GMT

Let me know if this is what you were looking for mate

Re: Create New Column

Thu, 09 May 2013 10:57:34 GMT

I obtain the same results. The problem I think is because the Column 'VALUE' is a Variable and when I include the variable in the expression, I don't have results.

Thanks

Re: Create New Column

Thu, 09 May 2013 11:33:16 GMT

hmmm why not upload your qvw or a test version with the variable.

If the value is a variable then only a single value will be selected and this essentially becomes your total.

Anyway, if you upload a sample document I can have a look and see what we can come up with

Re: Create New Column

er_mohit — Thu, 09 May 2013 11:47:45 GMT

if you talking about chart but

the new create column gives you the total for every row

if you want the same column as previous one then use sum(Column(1)) or what ever you want depending upon the expression column

but if you want total then sum(total Column(1)) it gives you all the total for every row

or in load script try this

Test:

LOAD * INLINE [

CATEGORY, VALUE

1, 1000

2, 2000

3, 1500

4, 1345

];

LOAD sum( VALUE) as New

Resident Test ;

hope it helps

See the attached file

Re: Create New Column

Thu, 09 May 2013 11:52:27 GMT

Byron,

Attached I sent you the document. Many thanks

Re: Create New Column

Thu, 09 May 2013 12:08:06 GMT

Hey mate,

the problem is the variable because that variable does not exists (check variable overview)

Now all you have to do is identify what measure it was suppose to sum and replace the variables inside that expression with the measure you want

Re: Create New Column

Thu, 09 May 2013 12:12:47 GMT

try this

tab:

LOAD

CATEGORY, VALUE

from table1;

output:

LOAD sum( VALUE) as Total

Resident tab ;

Re: Create New Column

Thu, 09 May 2013 12:29:18 GMT

I need the total of the Column in each row of the next column.

Re: Create New Column

Thu, 09 May 2013 12:46:23 GMT

The problem is that VALUE column is not a field in the table, as you can see in my document