topic Re: Tally Data into Qlikview in QlikView

Tally Data into Qlikview

Anonymous — Mon, 25 Aug 2014 12:38:04 GMT

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

Re: Tally Data into Qlikview

ashfaq_haseeb — Mon, 25 Aug 2014 12:39:21 GMT

Hi,

Try

text(yourfield) as Field

Regards

ASHFAQ

Re: Tally Data into Qlikview

qv_jagan — Mon, 25 Aug 2014 12:42:28 GMT

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

Re: Tally Data into Qlikview

Anonymous — Mon, 25 Aug 2014 12:43:00 GMT

not working

Re: Tally Data into Qlikview

Anonymous — Mon, 25 Aug 2014 12:44:45 GMT

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

Re: Tally Data into Qlikview

ashfaq_haseeb — Mon, 25 Aug 2014 12:47:32 GMT

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

Re: Tally Data into Qlikview

Anonymous — Mon, 25 Aug 2014 13:02:26 GMT

I have tried but not getting the result...

Any other solution????

Re: Tally Data into Qlikview

Mon, 25 Aug 2014 13:08:22 GMT

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

Re: Tally Data into Qlikview

ashfaq_haseeb — Mon, 25 Aug 2014 13:08:37 GMT

Send me your script part.

Regards

ASHFAQ

Re: Tally Data into Qlikview

Anonymous — Mon, 25 Aug 2014 13:18:48 GMT

Marius,

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

Regards,

Balraj