topic Inserting Columns in a table in QlikView

Inserting Columns in a table

Mon, 14 Aug 2017 02:15:10 GMT

Hi,

I have pulled some data via an Oracle Database through an OLEDB connection, and would like to know if it is possible to insert a new column of data into the existing table which makes use of an expression of the initial extracted data. An example is as below:

ID	Country	Last Connection	Last Connection (New Column)
ID1	Country1	12:28:33 14/8/17	Less than 3 days
ID2	Country1	1:10:22 9/8/17	3 - 7 days
ID3	Country2	9:34:11 4/7/17	More than 7 days

I am now currently able to group the data by Countries as the first three rows of data was pulled together via the OLEDB connection, but I am having trouble inserting a new column, as I would like to be able to display the data in terms of a chart, to show the number of days since last connection by country (showing the classification of days, instead of the exact time of the connection).

I have tried inserting a List Box, with an expression in it to calculate the values, but it is unable to be put into the Quick Chart Wizard as it is not seen as a field.

Any help for this would be much appreciated!

Re: Inserting Columns in a table

Anil_Babu_Samineni — Mon, 14 Aug 2017 08:12:54 GMT

Same Question?

Data from OLEDB Connection - Adding Columns

Re: Inserting Columns in a table

arvind_patil — Mon, 14 Aug 2017 09:07:35 GMT

Hi Jonathan,

Please find Below:

If(Today()-Floor(Date(Date#([Last Connection],'hh:mm:ss DD/MM/YYYY'))) < 3,'Less than 3 days',
If(Today()-Floor(Date(Date#([Last Connection],'hh:mm:ss DD/MM/YYYY'))) > 7,'More than 7 days',
'3 - 7 days'))

Thanks,

Arvind Patil

Re: Inserting Columns in a table

sonkumamon — Mon, 14 Aug 2017 10:25:11 GMT

Why don't you add the column in the LOAD script instead of expression?