Tally Data into Qlikview

[Anonymous]

Hello All,

I have created a Tally Data Extractor to load data into Qlikview.

I am getting textual data of Tally but not getting any numeric values but field getting loaded.

Can some body help why I am not getting numeric values of tally into QV?

Does it required any standard format to get Tally numeric field values into Qlikview?

Regards,

Balraj

[ashfaq_haseeb]

Hi,

Try

text(yourfield) as Field

Regards

ASHFAQ

[qv_jagan]

Hi Balraj,

Are you extracting the data directly from Tally to Qlikview or you store the Tally data in flat file and then use it in qlikview.

Regards,

Jagan. V

[Anonymous]

not working

[Anonymous]

I am directly extracting from tally ......

[ashfaq_haseeb]

Hi,

Make sure you use that function while loading from database.

Its worth going through this post.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation

Regards

ASHFAQ

[Anonymous]

I have tried but not getting the result...

Any other solution????

[#8]

Hi Balraj,

When you load the data into QlikView use the num() function.

Example:

[TALLY DATA]:

LOAD

     num(Field)                    as NewField;

SQL SELECT *

FROM [xxx].[xxx].[xxx]

Regards,
Marius

[ashfaq_haseeb]

Send me your script part.

Regards

ASHFAQ

[Anonymous]

Marius,

I have already tried these things but not giving any numeric values, filed is still blank/null.

Regards,

Balraj