Add a calculated column

[#1]

Hello, I have added a new table box into my main sheet and used all available fields (my source is an excel sheet).  I would like to learn how to add a column into my table box which will calculate based on existing fields.  I could not see how to simply "add blank column" or similar.  I hope this makes sense.  Basically, like Excel - I would like to insert a blank column.

[vikasmahajan]

What is requirement , What you want to achieve ?

Vikas

[#3]

Hi Vikas

I would like to calculate the difference between two dates.  the two columns of data already exist in my source excel file but the calculated data does not. would like to have this new calculated field show in my table.

[tresesco]

Try like:

Interval(DateField1 - DatefIeld2, 'DD') as DiffDate

'DD', refers to your desired output format. You can modify this format as per your requirement (for hour-'hh', minute-'mm'...)

[vikasmahajan]

While loading excel in to Qlikview You can perform the calculations on excel columns means  if col(a) and col(b) you have in excel  then while loading this into qlikview along with load script you can perform Col(a)+Col(b) as Col(c). This way you can do the things.

Vikas

[rwunderlich]

Use a Straight Table Chart instead of a Table Box. Table Box only allows you to display existing data. Straight Table allows you to create additional columns using expressions.

-Rob

[#7]

Thanks Rob!