topic Re: few qestions in QlikView

few qestions

Fri, 09 Jan 2015 06:22:42 GMT

Dear all,

I have few question

1.Is it possible to load my qvw results to any odbc database?.

2.In my source file .csv I have value 123.456655.I want values only till two decimal places (like 123.45).

3.I want to load data to Qvd with 5 Column's where I have only 4 column's (Column1,Column2,Column3,Column4) from source file

the extra column should come with null values to Qvd.

If it possible,help me on this

Thanks in advance,

b.kasi

Re: few qestions

PrashantSangle — Fri, 09 Jan 2015 06:39:28 GMT

Hi,

2: Use Num(fieldName,'##,00.00') for rounding upto 2 decimal.

3: Try script like

Load field1,

field2,

field3,

field4,

'Null' as field1

from qvdName.qvd;

1: I think through Macro it is possible, But I am not sure about it.

Any Macro expert will help you on this requirement.

Regards

Re: few qestions

SunilChauhan — Fri, 09 Jan 2015 06:40:33 GMT

1)yes using Extention write back to database

2) Num(123.456655,'#.##') or fixed to 2 in number Tab of chart properties

tab:

Load

Column1,Column2,Column3,Column4,

'' as Column5

from path

store tab into path\tab.qvd

Re: few qestions

tresB — Fri, 09 Jan 2015 06:42:47 GMT

1. Yes you can. For 'how?', search this community with 'write back to database'

2. Use num(), like num(yournum, '##.##')

3. Possible, Try like:

Table:

Load

Col1,

....,

null() as Col5

From <>;

Store Table Into ..;

Re: few qestions

jagan — Fri, 09 Jan 2015 06:52:10 GMT

Hi,

Check this link to write to database in script

Inserting records into Database using Qlikview Script

Write Back to Database via ETL process (using CSV or XML)

Regards,

Jagan.

Re: few qestions

its_anandrjs — Fri, 09 Jan 2015 06:52:43 GMT

Hi,

Yes you can do this

1. By Macros and search write back to databse in qlik community

Few of them are

http://community.qlik.com/message/609774#609774

Write Back to Database via ETL process (using CSV or XML)

2. For Decimal two place use

Load

Num( FieldName, '#.##0,00')

From Source

Load

Num( FieldName, '#.##')

From Source

3. And for Loading null columns use

Load Field1,Field2,Field3,Field4, Null() as Field5,Null() as Field6

From Source;

Regards

Anand