topic Re: Add a calculated column in QlikView

Add a calculated column

Fri, 06 Sep 2013 03:49:34 GMT

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.

Re: Add a calculated column

vikasmahajan — Fri, 06 Sep 2013 04:44:06 GMT

What is requirement , What you want to achieve ?

Vikas

Re: Add a calculated column

Fri, 06 Sep 2013 04:55:47 GMT

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.

Re: Add a calculated column

tresB — Fri, 06 Sep 2013 04:59:54 GMT

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'...)

Re: Add a calculated column

vikasmahajan — Fri, 06 Sep 2013 05:00:27 GMT

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

Re: Add a calculated column

rwunderlich — Fri, 06 Sep 2013 05:07:34 GMT

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

Re: Add a calculated column

Fri, 03 Oct 2014 14:39:13 GMT

Thanks Rob!